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

121 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
shool8452315(None) 
school11410721school
sheol84318371sheol
shoal83920271shoal
shoo75929891shoo_
shook124920161shook
shools94919011shools
shoon84022011shoon
shoos84226361shoos
shoot84235911shoot
shorl84720251shorl
snool55118641snool
spool75219041spool
stool55619891stool
bhoot104322102bhoot
cholo105217972cholo
chook146015042chook
cool66940492_cool
dhooly13457142dhooly
drool65416102drool
fool75330592_fool
ghoul959052ghoul
hood85132332_hood
hoof106036582_hoof
hook116133282_hook
hooly115022222_hooly
hoop96129982_hoop
hoot75752102_hoot
howl107625692_howl
mool67533862_mool
pool65835952_pool
salol55222142salol
schools1249112schools
schorl1179812schorl
scoop95617162scoop
scoot75729152scoot
scowl1012012972scowl
shall85024052shall
shaul85418102shaul
shawl116217572shawl
sheal84927702sheal
shell84424122shell
sheols94614162sheols
shiel811023772shiel
shill85325332shill
shmo95318102shmo_
shnook1366342shnook
shoals94215792shoals
shoaly124010772shoaly
shoat85633952shoat
shock144917032shock
shod86225062sh_od
shoe75933442sh_oe
shoed95723012shoed
shoer84722162shoer
shoes85429662shoes
shog86025142sh_og
shogi95014012shogi
shogs95319712shogs
shoji15419962shoji
sholom11910112sholom
shone83725982shone
shooed103916082shooed
shoofly1634352shoofly
shooks134515632shooks
shooled115212662shooled
shoots94619362shoots
shop95629842sh_op
shops104222902shops
shore85432652shore
shorls94516202shorls
shorn85722182shorn
short85040532short
shot76150262sh_ot
shote85526102shote
shots84730852shots
shott85332192shott
should1038032should
shout85433172shout
shove114421042shove
shovel124611322shovel
show106229192sh_ow
shown115216482shown
shows115324582shows
showy145714012showy
shoyu1138912shoyu
shul75823152sh_ul
skoal93811462skoal
sloop76118912sloop
snood64616162snood
snook95115572snook
snools65715882snools
snoop75317172snoop
snoot55030142snoot
soil46138832s_oil
sokol94612292sokol
sol37256622s__ol
solo45538942s_olo
sook84933392s_ook
soon46240502s_oon
soot45761062s_oot
sotol54917652sotol
soul46435712s_oul
spoil75818652spoil
spoof105019012spoof
spook115416042spook
spools85115912spools
spoon74719442spoon
spoor75016352spoor
stood65517712stood
stook95218212stook
stools65117022stools
stoop75821542stoop
swoon85014782swoon
swoop105213432swoop
thiol87616042thiol
tool46735682_tool
whoof144612692whoof
whoop134211442whoop
whorl114612452whorl
wool76427372_wool

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.296603685.8
2DLD Change Limit538001211.40638264.6
3Display Results1211210.0304033.3
 (SQL Overall)1786911211.732103170.3
 
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.