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

103 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
others9391800(None) 
bothers124317751bothers
ethers94518411ethers
mothers123717621mothers
ochers113915301ochers
other84219101other_
otters64021511otters
pothers123818621pothers
aethers103614942aethers
anthers103715202anthers
bathers124720362bathers
botchers153511542botchers
bother115218062bother_
brothers133410832brothers
cithers124315772cithers
coshers123618182coshers
cotters94323452cotters
dithers114016152dithers
doters74423912dot_ers
dotters83715972dotters
etchers123411292etchers
ether84518772ether_
fathers133916502fathers
frothers14279812frothers
gathers114315072gathers
gophers1338982gophers
hers75844872__hers
ither84617602ither_
joshers174111592joshers
jotters143413802jotters
koshers144811802koshers
lathers104321882lathers
loathers113310442loathers
lotters73921062lotters
mithers123516732mithers
moshers124017842moshers
mother113718642mother_
mothery153710512mothery
mouthers133811302mouthers
northers1139332northers
noshers103614332noshers
notchers13279422notchers
noters64021002not_ers
nother93815962nother_
oaters65029792oaters
ocher104516102ocher_
ochery14319442ochery
ochres113510832ochres
ockers123813902ockers
offers12349962offers
oglers74313182oglers
oilers64721192oilers
ombers104214402ombers
omers76923192o_mers
orders74315992orders
ormers84316142ormers
osiers63412792osiers
ostlers72911202ostlers
ottars64112222ottars
otter54423972otter_
outers64230172outers
outhears11810392outhears
overs85224792o_vers
owners94210702owners
oxters134813272oxters
oyers87620882o_yers
pother113818852pother_
potherb14358682potherb
potherbs15387122potherbs
potters94024342potters
potzers184010542potzers
rotters74421392rotters
smothers13349932smothers
soothers113913432soothers
southers114214452southers
steers63820982steers
tethers103815312tethers
theirs94610352_theirs
thens85921832_thens
there87527392_there
theres96525472_theres
therm106018022_therm
therms115914872_therms
thews117416192_thews
tiers55526522_tiers
tithers104216732tithers
tochers123413092tochers
tokers104818892tokers
toners64128002toners
topers85025322topers
toters65026362toters
tother94117142tother_
totters74618732totters
towers94423672towers
toyers95516332toyers
tyers86220052_tyers
ushers94415532ushers
utters63817122utters
voters95017442vot_ers
wethers135214692wethers
withers134417752withers
wuthers133711522wuthers
zithers193911972zithers

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 Filter178691825510.360496363.9
2DLD Change Limit825511032.29635954.3
3Display Results1031030.0333121.2
 (SQL Overall)1786911032.68966452.6
 
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.