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

123 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
scoot7572915(None) 
coot67860381_coot
scoop95617161scoop
scoots85315941scoots
scot66242611sc_ot
scout75031451scout
shoot84235911shoot
snoot55030141snoot
soot45761061s_oot
afoot8420112afoot
ascot76522512asc_ot
bhoot104322102bhoot
boot67759372_boot
cloot76127052cloot
clot66542422_clot
coat67558352_coat
coft97939682_coft
colt67158242_colt
coo59566362_coo_
coof96643272_coof
cook107236932_cook
cool66940492_cool
coon67248942_coon
coop87238652_coop
coopt95929852_coopt
coos67456492_coos
coots75636842_coots
cost68057942_cost
cot510483222_c_ot
escort84616482escort
escot75320082esc_ot
foot76248012_foot
hoot75752102_hoot
loot46955822_loot
moot67653622_moot
oot311274692__oot
root45655922_root
sabot7931782sabot
scant79735072scant
scart76139772scart
scat65848372sc_at
scatt76030092scatt
scent75831622scent
school11410722school
scion72214992scion
scoff134413342scoff
scold85414862scold
scone74621832scone
scooch13228122scooch
scoops105414362scoops
scootch1434462scootch
scooted103612282scooted
scooter93312872scooter
scop85925522sc_op
scope94821482scope
scops95820192scops
score75526742score
scorn75817452scorn
scots74025912scots
scour75315532scour
scouth115011152scouth
scouts84817942scouts
scow96021422sc_ow
scowl1012012972scowl
scows106617802scows
scrod85115072scrod
scroop10299782scroop
scrota8310202scrota
scut65835542sc_ut
shoat85633952shoat
shoo75929892shoo_
shook124920162shook
shool84523152shool
shoon84022012shoon
shoos84226362shoos
shoots94619362shoots
short85040532short
shot76150262s_hot
shott85332192shott
shout85433172shout
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

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 Limit538001231.42337807.4
3Display Results1231230.0304100.0
 (SQL Overall)1786911231.766101184.0
 
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.