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

117 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
scoots8531594(None) 
coots75636841_coots
scoops105414361scoops
scoot75729151scoot_
scots74025911sc_ots
scouts84817941scouts
shoots94619361shoots
snoots64216681snoots
soots55536211s_oots
ascots85312512asc_ots
bhoots11459912bhoots
boots75837972_boots
cloots85113692cloots
clots75627642_clots
coats75635002_coats
colts76633292_colts
coofs105924712_coofs
cooks115429142_cooks
cools75632632_cools
coons76737282_coons
coops96229642_coops
coopts105814582_coopts
coos67456492_coo_s
coot67860382_coot_
costs77231142_costs
cots68054842_c_ots
escorts9418402escorts
escots84211742esc_ots
foots85528282_foots
hoots84830252_hoots
loots55431422_loots
moots75831662_moots
oots46446442__oots
roots55933672_roots
sabots8314702sabots
scants85219722scants
scarts85321492scarts
scats75930602sc_ats
scatts85914662scatts
scents85317022scents
schools1249112schools
scions82612242scions
scoffs14347502scoffs
scolds95011232scolds
scones84521302scones
scooch13228122scooch
scoop95617162scoo_p
scootch1434462scootch
scooted103612282scooted
scooter93312872scooter
scooters103511032scooters
scopes104719592scopes
scops95820192sc_ops
scores84725922scores
scorns85713022scorns
scot66242612sc_ot_
scours84913592scours
scout75031452scout_
scouth115011152scouth
scouths12527892scouths
scowls11549592scowls
scows106617802sc_ows
scrods94111612scrods
scroops11288252scroops
scrota8310202scrota
scuts74522522sc_uts
shoats94117082shoats
shooks134515632shooks
shools94919012shools
shoos84226362shoo_s
shoot84235912shoot_
shorts95321742shorts
shots84730852s_hots
shotts93614702shotts
shouts94017722shouts
skorts104211302skorts
sloops85513622sloops
slots54830532s_lots
smolts84411882smolts
smooth11259202smooth
smooths12216322smooths
snoods74312452snoods
snooks104412832snooks
snools65715882snools
snoops84314172snoops
snoot55030142snoot_
snooty94211512snooty
snorts64116502snorts
snots55225122s_nots
snouts64915872snouts
softs85019232s_ofts
sooks94425452s_ooks
soot45761062s_oot_
sooth85924062s_ooth
sooths95715592s_ooths
sooty84924842s_ooty
sorts54536662s_orts
sots45552452s__ots
spoofs114011812spoofs
spooks124312932spooks
spools85115912spools
spoons84116022spoons
spoors84014032spoors
sports84619182sports
spots74424112s_pots
spouts85115112spouts
stoats65117482stoats
stooks105115372stooks
stools65117022stools
stoops85917892stoops
stots54828552s_tots
stotts64612862stotts
stouts65019002stouts
swoons94511142swoons
swoops114910922swoops
swots85518432s_wots
toots55331872_toots

Search took 10 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 Filter178691825510.796224486.2
2DLD Change Limit825511177.92010423.1
3Display Results1171170.0462543.5
 (SQL Overall)1786911178.76220393.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.