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

154 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
toff10592990(None) 
boff124727331boff
coff126930781coff
doff116225781doff
off96331631_off
teff106023761teff
tiff104727721tiff
toffs116016721toffs
toffy145310281toffy
toft77441651toft
tofu76921331tofu
tuff104528521tuff
aff95537612_aff
baff124632272baff
biff125026892biff
boffo136010372boffo
boffs134915502boffs
buff125229862buff
caff125631672caff
coffs134916302coffs
coft97939682coft
coif96337912coif
coof96643272coof
corf95941482corf
cuff125327992cuff
cutoff1436562cutoff
daff115229682daff
diff116228842diff
doffs125614332doffs
duff114326642duff
eff96128622_eff
feoff10711052feoff
gaff114828152gaff
golf85731182golf
goof85436872goof
guff114624932guff
hoof106036582hoof
howf136127202howf
howff175110492howff
huff135623842huff
iff96730392_iff
jiff175321412jiff
loaf76734902loaf
loft76539142loft
loof78141052loof
luff104426702luff
miff125625062miff
muff124723862muff
naff105128932naff
oaf65952882_oaf
of58247772_o_f
offs107117012_offs
oft67744062_oft
poof95541662poof
pouf95732642pouf
pouff135215422pouff
puff125525432puff
putoff1436422putoff
raff104933042raff
riff104430102riff
rolf75134872rolf
roof75738832roof
ruff105127652ruff
scoff134413342scoff
setoff1238912setoff
sofa75625602sofa
soft76942822soft
staff113817712staff
stiff114219242stiff
stuff113817052stuff
taffy145110822taffy
teffs115111732teffs
tiffs114414882tiffs
tipoff1436382tipoff
to218858982to__
toad55830182toad
toby96322292toby
tod49457072to_d
tods56141842tods
tody86327212tody
toe310166852to_e
toea46732332toea
toed56137042toed
toes46956442toes
toffee123311012toffee
tofts84919242tofts
tofus86415422tofus
tog410255042to_g
toga57027412toga
togs57242432togs
toil46536282toil
toit46353062toit
toke86738492toke
tola45236332tola
told56132202told
tole46052902tole
toll45535262toll
tolu45529152tolu
tom514358052to_m
tomb89029652tomb
tome67543192tome
toms68343492toms
ton310265102to_n
tone46953742tone
tong56434352tong
tons46553052tons
tony75635152tony
too38965422to_o
took86531072took
tool46735682tool
toom66532932toom
toon47740632toon
toot45958882toot
top510560682to_p
tope65946382tope
toph96326872toph
topi67830392topi
topo66932402topo
tops66248122tops
tor39261682to_r
tora47545992tora
torc66333352torc
tore47359322tore
tori47542152tori
torn46044252torn
toro48045682toro
torr45630902torr
tors46157382tors
tort46967462tort
tory75840542tory
tosh74826812tosh
toss45637972toss
tost48351922tost
tot38884772to_t
tote46643672tote
tots46654122tots
tour45530372tour
tout46753822tout
tow610557362to_w
town76928702town
tows78545552tows
towy105325472towy
toy69655192to_y
toyo76925452toyo
toys78036342toys
tref77030992tref
tufa75016612tufa
tuffs115118262tuffs
tuft76929512tuft
turf75334052turf
waff134228042waff
wolf105729562wolf
woof106532422woof
yaff135324262yaff

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 Filter178691298720.0762351197.4
2DLD Change Limit298721541.90615672.6
3Display Results1541540.0801925.0
 (SQL Overall)1786911542.06286659.1
 
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.