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 “soave” with Change Limit: [1] [2]

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

143 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
soave8421905(None) 
save75741361s_ave
shave114425891shave
slave84224031slave
soaves94218671soaves
solve85618941solve
stave85324991stave
suave83519871suave
agave95314032agave
ave67748702__ave
brave104925502brave
cave95941262_cave
clave105420152clave
cove95837072co_ve
crave105626312crave
deave95022332deave
dove85131562do_ve
drave95219272drave
eave75733582_eave
fave105532962_fave
gave84634052_gave
grave94624872grave
have106137072_have
heave114521812heave
hove107132222ho_ve
knave12389462knave
lave75642142_lave
leave84723722leave
loaves94813852loaves
love75234762lo_ve
move96630722mo_ve
nave75732312_nave
novae85913122novae
oaves84925612_oaves
pave96133892_pave
poove104514302poove
psoae74411622psoa_e
rave75542092_rave
reave84528022reave
rove75136982ro_ve
sabe66140572s_abe
sade55544472s_ade
sae38365182s_a_e
safe75930952s_afe
sage55044592s_age
sake85244962s_ake
sale44959702s_ale
salve85022132salve
same65245642s_ame
sane45954342s_ane
sate45556102s_ate
saved95127112s_aved
saver84831252s_aver
saves85838632s_aves
scale74629142scale
scape96921842scape
scare75334462scare
serve85425962serve
shade95125582shade
shake124726402shake
shale85332832shale
shame105726702shame
shape105125112shape
share86437082share
shaved135118382shaved
shaven124213302shaven
shaver123718912shaver
shaves125224932shaves
shavie124312422shavie
sheave124514002sheave
shive114423422shive
shove114421042shove
sieve84918842sieve
skate94721552skate
skive124614112skive
slake93724052slake
slate55438282slate
slaved104017042slaved
slaver94419612slaver
slaves95023022slaves
slavey124011802slavey
sleave94714152sleave
smaze165012932smaze
snake94821112snake
snare54429982snare
soak87227662soa_k
soaked114717592soaked
soaker105717532soaker
soaks95220292soaks
soap65831132soa_p
soaped95817972soaped
soaper84517872soaper
soaps75120712soaps
soapy106114782soapy
soar46838672soa_r
soared74324292soared
soarer64522242soarer
soars54732512soars
socage91012122socage
socle7419572socle
soever94412092soever
soke85436262so_ke
solace83415822solace
solate64526072solate
sole46053672so_le
solved105312932solved
solver94016702solver
solves95018222solves
some66040382so_me
sonde64622832sonde
sone46649982so_ne
sore47059532so_re
souse56530772souse
space95325672space
spade84423322spade
spae65034322spa_e
spake114322742spake
spale74929212spale
spare75135562spare
spate74731582spate
spavie113611382spavie
stade64825302stade
stage65330192stage
stake95927532stake
stale55637102stale
stane55933002stane
stare54440262stare
starve94613742starve
state56237332state
staved103918052staved
staves94525192staves
stoae55024262stoa_e
stove85220252stove
suaver93014232suaver
swage94919562swage
swale85221592swale
sware85828212sware
swive115316192swive
trave85223032trave
wave105234732_wave
weave115218532weave
wove105624312wo_ve
zouave1833572zouave

Search took 2 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 Filter178691538000.313570897.8
2DLD Change Limit538001431.56334421.0
3Display Results1431430.0304766.7
 (SQL Overall)1786911431.90693751.8
 
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.