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

137 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
ofter8411687(None) 
after85719791after
lofter94614721lofter
oater55433731oater
offer114311381offer
often84611411often
otter54423971otter
outer55633301outer
oxter123414091oxter
softer94015311softer
afters94717072afters
alter54828502alter
apter76120202apter
aster55434892aster
biter75030032biter
boater84622092boater
bolter83920752bolter
cater74840722cater
citer74827332citer
coater84329572coater
coffer144112862coffer
colter84625092colter
cooter85128612cooter
copter109822012copter
coster84331292coster
cotter84926672cotter
couter84930222couter
crofter12299572crofter
cuter74728232cuter
dafter104813342dafter
dater65332312dater
defter104215922defter
deter65028042deter
doffer133911352doffer
doter65428622doter
dotter74419342dotter
eater54639842eater
enter54726382enter
ester54727712ester
fer66646122_f_er
footer94320772footer
foster94322222foster
foyer116416552foyer
gater64533652gater
gofer94814282gof_er
goffer13409512goffer
goiter74116202goiter
hafter124815882hafter
hater85034752hater
hefter124313922hefter
hooter94123932hooter
hotter94720082hotter
inter55028492inter
jolter133513092jolter
jotter134315632jotter
kiter95523212kiter
later54843922later
lefter93613432lefter
lifter93814812lifter
liter54736342liter
lofted103811892lofted
lofters103912902lofters
loftier1037762loftier
loiter64619172loiter
looter64222322looter
lotter64025602lotter
mater74438862mater
meter75130322meter
miter75734792miter
molter84119422molter
mooter83921092mooter
muter74525542muter
niter55028972niter
noter55025642noter
oaten55222402oaten
oaters65029792oaters
ocher104516102ocher
ocker113915752ocker
octet7324062octet
odder74515392odder
offed12359162offed
offers12349962offers
oft67744062oft__
oftener1035922oftener
oftest91212002oftest
ogler65917442ogler
oiler54628282oiler
older65121172older
omber95316442omber
omer67028392o_mer
opted84914272opted
order65019362order
ormer75218372ormer
osier53518012osier
ostler63312192ostler
other84219102other
ottar54313992ottar
otters64021512otters
ouster64223732ouster
outed65429062outed
outers64230172outers
outre53922202outre
over77227342o_ver
owner84613312owner
oxters134813272oxters
oyer75927652o_yer
oyster94111702oyster
pater74740722pater
peter74427592peter
poofter1237162poofter
porter84224412porter
poster84129172poster
potter83926982potter
pouter83923982pouter
powter114116032powter
rafter94517582rafter
rater54943282rater
rooter64926032rooter
roster64329082roster
rotter64325462rotter
router65025842router
sifter94516232sifter
soften9429492soften
sorter64425092sorter
souter64225922souter
tater54138612tater
titer55430612titer
tooter64420802tooter
toter55932132toter
totter65021462totter
touter63821032touter
tufter9319932tufter
utter54218762utter
voter85121052voter
wafter124114612wafter
water84733312water
zoster153715852zoster

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.0762351197.4
2DLD Change Limit538001371.56334421.0
3Display Results1371370.0462978.3
 (SQL Overall)1786911371.685106048.1
 
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.