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 “oxters” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

100 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
oxters13481327(None) 
oaters65029791oaters
otters64021511otters
outers64230171outers
oxter123414091oxter_
afters94717072afters
alters64924222alters
asters65631602asters
biters83925242biters
boaters93419242boaters
bolters94017802bolters
boxers155013482box_ers
caters85336502caters
citers85022982citers
coaters93525792coaters
colters93522442colters
cooters94525722cooters
copters113621282copters
costers94128332costers
cotters94323442cotters
couters93827302couters
daters74827372daters
deters74724682deters
doters74423912doters
dotters83715972dotters
eaters65535952eaters
enters64425642enters
esters64627732esters
extern1348472extern
externs1438232externs
footers104618332footers
fosters104220102fosters
gaters74728642gaters
goiters84014442goiters
haters94930402haters
hooters104520472hooters
inters64328052inters
jolters143711992jolters
jotters143413802jotters
kiters105218592kiters
liters65429882liters
lofters103912902lofters
loiters74116612loiters
looters74419162looters
lotters73921062lotters
maters85032392maters
meters85625832meters
miters84328782miters
molters93816972molters
mooters93818622mooters
niters64624212niters
noters64021002noters
oater55433732oater_
ochers113915302ochers
ockers123813902ockers
octets839402octets
offers12349962offers
ofter84116872ofter_
oglers74313182oglers
oilers64721192oilers
ombers104214402ombers
omers76923192o_mers
orders74315992orders
ormers84316142ormers
osiers63412792osiers
ostlers72911202ostlers
others93918002others
ottars64112222ottars
otter54423972otter_
ousters74122792ousters
outer55633302outer_
overs85224792o_vers
owners94210702owners
oxes116530722ox_e_s
oyers87620882o_yers
oysters103411692oysters
paters84935832paters
peters86624592peters
porters93722702porters
posters93928012posters
potters94024342potters
pouters94221872pouters
powters124015662powters
raters63936582raters
rooters74522932rooters
rosters73727542rosters
rotters74421392rotters
routers74822872routers
sorters74221132sorters
souters74422602souters
taters64932202taters
titers64526412titers
tooters73818772tooters
toters65026362toters
totters74618732totters
touters74018352touters
utters63817122utters
voters95017442voters
waters95030632waters
zosters163015412zosters

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.343520965.0
2DLD Change Limit825511002.26636430.3
3Display Results1001000.0303333.3
 (SQL Overall)1786911002.63967711.6
 
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.