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

147 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
shoot8423591(None) 
bhoot104322101bhoot
hoot75752101_hoot
scoot75729151scoot
shoat85633951shoat
shoo75929891shoo_
shook124920161shook
shool84523151shool
shoon84022011shoon
shoos84226361shoos
shoots94619361shoots
short85040531short
shot76150261sh_ot
shott85332191shott
shout85433171shout
snoot55030141snoot
soot45761061s_oot
afoot8420112afoot
bhoots11459912bhoots
boot67759372_boot
cahoot11416472cahoot
chook146015042chook
chott103923932chott
cloot76127052cloot
coot67860382_coot
dhooti1035662dhooti
foot76248012_foot
ghost96318762ghost
holt77852582_holt
hood85132332_hood
hoof106036582_hoof
hook116133282_hook
hoop96129982_hoop
hoots84830252_hoots
hooty115022442_hooty
host77852832_host
hot67776062_h_ot
loot46955822_loot
moot67653622_moot
oot311274692__oot
phot95534362ph_ot
photo104417232photo
reshoot102513892reshoot
root45655922_root
sabot7931782sabot
school11410722school
scoop95617162scoop
scoots85315942scoots
scot66242612s_cot
scout75031452scout
shaft115725272shaft
shalt85534492shalt
shat76456602sh_at
sheet84836962sheet
shent85933502shent
sheol84318372sheol
sheroot10414372sheroot
shift114225142shift
shirt84533902shirt
shist84829612shist
shit76745942sh_it
shmo95318102shmo_
shnook1366342shnook
shoal83920272shoal
shoats94117082shoats
shock144917032shock
shod86225062sh_od
shoe75933442sh_oe
shoed95723012shoed
shoer84722162shoer
shoes85429662shoes
shog86025142sh_og
shogi95014012shogi
shogs95319712shogs
shoji15419962shoji
sholom11910112sholom
shone83725982shone
shooed103916082shooed
shooks134515632shooks
shools94919012shools
shooter103013992shooter
shop95629842sh_op
shops104222902shops
shore85432652shore
shorl84720252shorl
shorn85722182shorn
shorts95321742shorts
shorty124313202shorty
shote85526102shote
shots84730852shots
shotts93614702shotts
shouts94017722shouts
shove114421042shove
show106229192sh_ow
shown115216482shown
shows115324582shows
showy145714012showy
shoyu1138912shoyu
shunt85226512shunt
shut76137592sh_ut
skort94925642skort
sloop76118912sloop
slot46049832s_lot
smolt74824162smolt
smooth11259202smooth
snood64616162snood
snook95115572snook
snool55118642snool
snoop75317172snoop
snoots64216682snoots
snooty94211512snooty
snort54833752snort
snot44745452s_not
snout54530632snout
soft76942822s_oft
sook84933392s_ook
soon46240502s_oon
sooth85924062s_ooth
soots55536212s_oots
sooty84924842s_ooty
sort46264812s_ort
sot310384302s__ot
spoof105019012spoof
spook115416042spook
spool75219042spool
spoon74719442spoon
spoor75016352spoor
sport75935982sport
spot65540692s_pot
spout75029632spout
stoat57135952stoat
stood65517712stood
stook95218212stook
stool55619892stool
stoop75821542stoop
stopt76528352stopt
stot46347332s_tot
stott56929792stott
stout57434052stout
swoon85014782swoon
swoop105213432swoop
swot75134662s_wot
toot45958882_toot
upshoot1256692upshoot
whoof144612692whoof
whoop134211442whoop
whort114623692whort

Search took 3 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 Limit538001471.68631909.8
3Display Results1471470.0304900.0
 (SQL Overall)1786911472.02988068.5
 
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.