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

102 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
shmo9531809(None) 
schmo124510201schmo
shoo75929881shoo
sumo67326311sumo
ammo85520132ammo
camo85731752camo
chao95727312chao
chemo12313632chemo
demo77427552demo
hao67251122_hao
hm78126732_hm_
hmm106218992_hmm
ho510258272_h_o
homo96126472homo
limo65529732limo
memo85924792memo
mho86624622mh_o
mo49158482__mo
ohm86523012ohm_
ohms95514032ohms
oho66534382oh_o
pomo85828452pomo
rho65924832rh_o
sago56332672sago
sambo95118012sambo
same65245642same
samp85733592samp
schmoe13328332schmoe
schmos13379152schmos
sego56525182sego
seme65836652seme
semi65127222semi
sh56828522sh__
sha69837782sh_a
shad86230912shad
shag86430562shag
shah105627782shah
shako125516082shako
sham96436352sham
shame105726702shame
shamos114216982shamos
shamoy14379912shamoy
shams105829412shams
shat76456592shat
shaw108132552shaw
shay107133342shay
she66837692sh_e
shea76031572shea
shed86536152shed
sheol84318362sheol
shes75734352shes
shew108030762shew
shh97121072sh_h
shim95827842shim
shims104422542shims
shin75634302shin
ship95228232ship
shit76745932shit
shiv105721162shiv
shmoes114612092shmoes
shod86225052shod
shoe75933432shoe
shog86025132shog
shook124920152shook
shool84523142shool
shoon84022002shoon
shoos84226352shoos
shoot84235892shoot
shop95629832shop
shot76150242shot
show106229182show
shri76021692shri
shul75823152shul
shun75122772shun
shut76137582shut
shwa106014962shwa
shy96728192sh_y
silo46037912silo
sim56553132sim_
sima64730782sima
simp85228772simp
sims65737172sims
sixmo1448302sixmo
skimo116312532skimo
smog76317412s_mog
so28855442s__o
solo45538942solo
som59153802som_
soma65635292soma
some66040382some
soms66239372soms
sum56346012sum_
sumos75720092sumos
sump86331532sump
sums65837582sums
sybo9714742sybo
thio77225412thio
tho67433962th_o
thro77726422thro
whamo135511262whamo
who95526772wh_o
whom127018172whom

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 Filter178691298720.0762351197.4
2DLD Change Limit298721020.90632971.3
3Display Results1021020.0333090.9
 (SQL Overall)1786911021.015176050.2
 
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.