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

120 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
scout7503145(None) 
scoot75729141scoot
scot66242601sco_t
scour75315531scour
scouth115011151scouth
scouts84817941scouts
scut65835541sc_ut
shout85433161shout
snout54530631snout
spout75029631spout
stout57434051stout
about75229082about
ascot76522512asco_t
bout66353292_bout
clout75330462clout
coat67558342_coat
coft97939682_coft
colt67158242_colt
coot67860382_coot
cost68057942_cost
cot510483222_co_t
count74932052_count
coup86729792_coup
court75532762_court
couth106122482_couth
cut57957662_c_ut
escort84616482escort
escot75320082esco_t
flout86226202flout
glout65925812glout
gout56646002_gout
grout65330422grout
knout95018262knout
lout45952142_lout
out38072152__out
pout65752552_pout
rout46153282_rout
sacbut10811942sacbut
scant79735072scant
scart76139772scart
scat65848372sc_at
scatt76030092scatt
scaup95515992scaup
scaur75814902scaur
scent75831622scent
schuit1139562schuit
schul102510412schul
scoff134413342scoff
scold85414862scold
scone74621832scone
scoop95617162scoop
scoots85315932scoots
scop85925522sco_p
scope94821482scope
scops95820192scops
score75526732score
scorn75817442scorn
scots74025902scots
scours84913582scours
scouse84113632scouse
scouted104112032scouted
scouter93313322scouter
scouths12527892scouths
scow96021422sco_w
scowl1012012972scowl
scows106617802scows
scrub94914202scrub
scrum95418192scrum
scud76221282sc_ud
scum85924522sc_um
scup84822382sc_up
scuta75815752sc_uta
scute75520942sc_ute
scuts74522522sc_uts
setout64719462setout
shoat85633942shoat
shoot84235892shoot
short85040522short
shot76150242sho_t
shott85332172shott
shouts94017712shouts
shut76137582s_hut
sickout1359372sickout
skort94925632skort
slot46049822slo_t
slut45040592s_lut
smolt74824162smolt
smut66629782s_mut
snoot55030132snoot
snort54833752snort
snot44745442sno_t
snouts64915862snouts
snouty9419952snouty
soft76942822s_oft
soot45761052s_oot
sort46264812s_ort
sot310384292s_o_t
sou37853692s_ou_
souk86127172s_ouk
soul46435712s_oul
soup66232912s_oup
sour45935892s_our
sous46947212s_ous
south85223572s_outh
sport75935982sport
spot65540682spo_t
spouts85115112spouts
sprout8419402sprout
stoat57135952stoat
stopt76528352stopt
stot46347322sto_t
stott56929782stott
stoup75517072stoup
stour54916742stour
stouts65019002stouts
strut56030732strut
swot75134652swo_t
swoun84811492swoun
tout46753822_tout
trout57332572trout

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.0961861364.6
2DLD Change Limit538001201.42037887.3
3Display Results1201200.0333636.4
 (SQL Overall)1786911201.549115358.9
 
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.