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

103 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
smaragd113439(None) 
smaragde1242831smaragde
smaragds1243301smaragds
maraud938942_maraud
smaragdes1343032smaragdes
smarted105012612smarted
emerald1046923emerald
farad95720673_fara_d
garage8314513_garage
garaged1039253_garaged
manage93818903_manage
managed113212603_managed
mara67444573_mara__
maraca10314153_maraca
maras75443293_mara_s
marauds1037553_marauds
margay12310593_margay
marge85328333_mar_ge
marked133921623_marked
marled95523163_marled
marred95421043_marred
marted94425213_marted
mazard1838763_mazard
mirage92313653_mirage
salad65321833s_ala_d
samara8313853samara__
samaras9312913samara_s
sambaed1238303sambaed
saran53730303s_ara_n
sarans64224433s_arans
sarape84817573s_arape
sard55344243s_ar__d
sarge65531133s_ar_ge
sargo65424413s_ar_go
sarod65325873s_ar_od
savage10410173s_avage
savaged1236993s_avaged
scalage103110533scalage
scarab10310063scara_b
scarabs1137293scarabs
scared95227293scar_ed
scarfed134711183scarfed
scarped124314403scarped
scarred104512633scarred
scarted104816123scarted
scrag85916173s_crag_
scrags95713803s_crags
seabag938473seabag_
seabags1037483seabags
seared75232843sear_ed
seaward1148183seaward
shard96125963shar__d
shared105829063shar_ed
sharked153613913sharked
sharped134112053sharped
smacked163710993smacked
smallage1145183smallage
smaragdine1452123smaragdine
smaragdite1451903smaragdite
smarm95517603smar__m
smarms105712533smar_ms
smarmy13629353smar_my
smart75834093smar__t
smartass1044273smartass
smarten9348863smarten
smarter94113133smarter
smartie9310173smartie
smartly12497433smartly
smarts86218003smar_ts
smarty115013793smar_ty
smashed133711223smashed
smeared104510623smear_ed
smerked14327283smerked
smirked14307233smirked
snared74824553snar_ed
snarfed11378753snarfed
snarled83612363snarled
soakage1236103soakage
soared74324293soar_ed
spared95427493spar_ed
sparge94216053spar_ge
sparged113512763sparged
sparid94016933spar_id
sparked143513143sparked
sparoid102311543sparoid
sparred104512863sparred
sprag86418693s_prag_
sprags95715823s_prags
stalag7310023stalag_
stalags838643stalags
stared75429873star_ed
starred85013453starred
started84217323started
starved114911573starved
storage8310473storage
strand74514823s_trand
svaraj1634963svara_j
swaraj1636023swara_j
sward94221463swar__d
swarded1238153swarded
swarmed1367483swarmed
tiaraed837053tiaraed
umbrage1236723umbrage

Search took 8 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.390458182.1
2DLD Change Limit1340271037.08018930.4
3Display Results1031030.0462239.1
 (SQL Overall)1786911037.51623774.7
 
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.