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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

94 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
sperm9321601(None) 
perm85834631_perm
sperms102512601sperms
aper66336232aper_
apers76629132apers
apery106517902apery
asper75520432asper_
aspers86220312aspers
berm86732752_berm
deperm1139362deperm
derm76031892_derm
germ75428962_germ
herm95636152_herm
oosperm1134882oosperm
opera7313572opera
per56353092_per_
pere66450262_pere
peri65636972_peri
perk106232842_perk
perms95524512_perms
perp89029892_perp
pert66759322_pert
perv97224812_perv
seam66645972s_eam
seem65438562s_eem
seer45547042seer_
seers55136382seers
ser36752402s_er_
sera46141392s_era
sere46153472s_ere
serf76340112s_erf
sers45746652s_ers
serum75223472s_erum
sherd96321152sherd
skelm114211282skelm
smarm95517602smarm
smerk115412722smerk
spam85930042sp_am
spar65433302spar_
spare75135562spare
spark114920892spark
spars75431542spars
spasm94514172spasm
speak114618672speak
spean74620512spean
spear75821062spear
spears84019472spears
spec85821972spe_c
speck135115652speck
specs96916672specs
sped76031492spe_d
speed85526622speed
speel74420762speel
speer74623902speer
speers85019952speers
speil75618642speil
speir75315362speir
speirs85013232speirs
spell75020302spell
spelt75430192spelt
spend85619332spend
spent75532832spent
spermic1338522spermic
spew95421872spe_w
spews105015922spews
sphere113313652sphere
sphery14318882sphery
spier75728032spier_
spiers84421742spiers
spire75828692spire
spirem104214162spirem
spirt75032952spirt
spiry105017352spiry
spore75428592spore
sport75935982sport
spree74830862spree
spry96819122sp_ry
spur65321192spur_
spurn74815452spurn
spurs74621522spurs
spurt77227982spurt
steam76322922steam
stem610628242ste_m
stere55328542stere
stern55319122stern
storm76520372storm
suer45334032suer_
suers55128482suers
super74924482super_
superb104410992superb
supers84622402supers
swarm106218832swarm
term66233152_term
therm106018022therm

Search took 5 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.186960704.3
2DLD Change Limit53800943.93613668.7
3Display Results94940.0631492.1
 (SQL Overall)178691944.18542698.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.