Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “scaleni” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

145 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
scaleni93688(None) 
scalene9310771scalene
scale74629142scale__
scaled94822442scale_d
scalenus1045542scalenus
scaler84321602scale_r
scalers93817262scalers
scales84529312scale_s
scaleup1134482scaleup
scaling103519372scaling
sileni63312142s_ileni
acaleph1453443acaleph
aculei839793acule_i
cadent94120353_cadent
calami10313423_calami
calends1039523_calends
calesa8412473_calesa
calkin123515493_calkin
casein83216453_casein
casini84615863_casini
catena8312473_catena
coloni85619203_coloni
esculent1047183esculent
galena74911093_galena
galenic1038693_galenic
salami8313103s_alami
sale44959703s_ale__
salep77022953s_ale_p
saleps85014903s_aleps
sales56055593s_ale_s
salient7419763s_alient
salina64221123s_alina
saline65132703s_aline
salmi7815863s_al_mi
salon55228553s_alon_
salons63823683s_alons
saluki1036203s_aluki
scabland1344293scabland
scalade10359263scalade
scalado10276473scalado
scalage103110533scalage
scalar83612433scal_ar
scalare93311833scalare
scalars93711903scalars
scald84818123scal__d
scalded11409763scalded
scaldic1235943scaldic
scalding12339393scalding
scalds94813693scal_ds
scalelike1545253scalelike
scalepan1244513scalepan
scalepans1343823scalepans
scaletail1143873scaletail
scaleups1243393scaleups
scalier94316913scalier
scaliest101714383scaliest
scall74420373scal__l
scallop11237643scallop
scalls84218203scal_ls
scalp95217983scal__p
scalped124411993scalped
scalpel11377713scalpel
scalpels12345883scalpels
scalper113912923scalper
scalpers123710863scalpers
scalping133410453scalping
scalps104315233scal_ps
scaly104718723scal__y
scampi12469103sca_mpi
scan65530453sca__n_
scandent1148493scandent
scanned104110893scanned
scanner94411813scanner
scans74625103sca__ns
scant79735073sca__nt
scape96921843scape__
scaped115519553scape_d
scapes105122263scape_s
scaping123715693scaping
scare75334463scare__
scared95227293scare_d
scarer84524603scare_r
scarers94618503scarers
scares85033003scare_s
scarey115016983scare_y
scaring103421973scaring
scarless10189053scarless
scarlet91516943scarle_t
scarlets10178573scarlets
scavenge1442813scavenge
scena74815783sc__ena
scend85516293sc__end
scene77220573sc__ene
scenic10510513sc__enic
scent75831623sc__ent
schlep1347093schle_p
schlepp1662953schlepp
schleps1445483schleps
sciaenid1153573sciaenid
sclera838883sc_lera
scolex1538243scole_x
screen85216013screen_
screens95212173screens
sculpin11236653sculpin
sealant73118303sealant
sealed74328363seale_d
sealer63928963seale_r
sealers74323553sealers
sealery104011053sealery
sealing83528563sealing
seamen84518563seamen_
selenic9410663s_elenic
shaken134113613shaken_
shale85332833shale__
shaled105023953shale_d
shales94731253shale_s
shaley123714993shale_y
shapen114414653shapen_
shaven124213303shaven_
silent64125843s_ilent
sklent103614353s_klent
smalti84111173smal_ti
solei55624333s_ole_i
spale74929213spale__
spales84728103spale_s
splenia948313s_plenia
splenic1148663s_plenic
splenii945543s_plenii
splent84720193s_plent
squalene1745613squalene
stale55637103stale__
staled74728103stale_d
stalely1039213stalely
staler64025823stale_r
stales65538293stale_s
stalest73720173stalest
staling83925423staling
stamen84115943stamen_
stamens93411483stamens
stelene7310253stelene
stolen64315063stolen_
sullen62914293sullen_
swale85221593swale__
swales93920763swale_s
talent6323323_talent

Search took 10 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911340270.1561145455.1
2DLD Change Limit1340271459.18614590.4
3Display Results1451450.0463152.2
 (SQL Overall)1786911459.38819034.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.