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 “snorkels” 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.

113 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
snorkels123441(None) 
snorkel1135421snorkel_
schnorkels1951772schnorkels
snookers12398652snookers
snorers74313802snor_ers
snores64324322snor_e_s
snorkeled1442882snorkeled
snorkeler1342662snorkeler
snorkelers1442272snorkelers
snorters83410582snorters
sorels63921162s_or_els
sorrels7310722s_orrels
bordels103911973_bordels
corbels113813593_corbels
corkers134118853_corkers
cormels113813373_cormels
cornels94716663_cornels
dorsels84412573_dorsels
ensorcels1143423ensorcels
forkers144615783_forkers
knockers13285733knockers
morels84820013_mor_els
morsels94112653_morsels
nickels13338653_nickels
noels56418703_no__els
normals92510903_normals
novels95512503_no_vels
oriels64914623__oriels
porkers134314933_porkers
saurels749303saur_els
schnorkel1842193schnorkel_
scorers94115323scor_ers
scores84725923scor_e_s
scorners10228493scorners
senores73218113senor_e_s
sharkers154011053sharkers
shekels1436043s_hekels
shirkers15319583shirkers
shnorrers1243533shnorrers
shockers17319463shockers
shores94830413shor_e_s
shorls94516203shor__ls
shortens11288993shortens
shovels13378393sho_vels
smirkers14316353smirkers
smokers13389323smo_kers
smokes124814343smo_ke_s
snackers143010223snackers
snakes103919603sn_ake_s
snarers74216663snar_ers
snares65329033snar_e_s
snarkily1534583snarkily
snarks104815733snark__s
snarlers8298753snarlers
snarls64016873snar__ls
sneakers12308643sneakers
snickers143010963snickers
snivels10336903sn_ivels
snooked123711493snooke_d
snooker113910303snooke_r
snooks104412833snook__s
snools65715883sno__ols
snoopers10319843snoopers
snoozers17296943snoozers
snoozes16289783snooze_s
snoozles17335563snoozles
snore55424953snor_e__
snored74819543snor_e_d
snorer64316763snor_e_r
snorkeling1542973snorkeling
snorted83813493snorte_d
snorter74412663snorte_r
snorts64116503snor__ts
snowbell13113593snowbell
snowbells14113493snowbells
snowbelt13114623snowbelt
snowbelts14112763snowbelts
snowless1145633snowless
snowmelt13114123snowmelt
snowmelts14112473snowmelts
soakers114114953s_oakers
sockets134012983s_ockets
sokes95031423s_o_ke_s
sokols10399093s_o_kols
sorbets93012513s_orbets
sorel56231443s_or_el_
sorely94618013s_or_ely
sores55454283s_or_e_s
sorners73416873s_orners
sorrel6413553s_orrel_
sorters74221133s_orters
sparkers144111313sparkers
sparkles143210493sparkles
spokes124417213spo_ke_s
spores84726613spor_e_s
sporters103714063sporters
sporules1037703sporules
starkers123712393starkers
stockers143411073stockers
stokers114515183sto_kers
stokes104821793sto_ke_s
stookers12449793stookers
storers75018683stor_ers
stores65533663stor_e_s
storeys10559653stor_eys
stories7324273storie_s
storks106115953stork__s
streels73811343s_treels
strokers123910903strokers
strokes114316323stroke_s
unreels7258313un_reels
workers144612693_workers
yokels13488063_yo_kels

Search took 9 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 Filter1786911461620.423422437.4
2DLD Change Limit1461621138.09318060.3
3Display Results1131130.0462456.5
 (SQL Overall)1786911138.56220870.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.