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

123 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
zosters16301541(None) 
costers94128331costers
fosters104220101fosters
posters93928011posters
rosters73727541rosters
zesters163517291zesters
zoster153715851zoster_
asters65631602_asters
basters94930302basters
bisters93922612bisters
boasters103915662boasters
boaters93419242boaters
bolsters103712452bolsters
bolters94017802bolters
boosters104013442boosters
busters94724132busters
casters94729902casters
coasters104317332coasters
coaters93525792coaters
colters93522442colters
cooters94525722cooters
copters113621282copters
coshers123618182coshers
costars94218012costars
coster84331292coster_
cotters94323442cotters
couters93827302couters
dosers75723632dos_ers
dossers84516232dossers
doters74423912do_ters
dotters83715972dotters
dusters84918362dusters
easters75125682easters
esters64627732_esters
festers104121392festers
footers104618332footers
foster94322222foster_
gasters85624292gasters
goiters84014442goiters
hoisters113513482hoisters
holsters113211942holsters
hooters104520472hooters
hosers95223962hos_ers
hosiers104212642hosiers
hostels103712312hostels
hostess103210242hostess
hostlers113310482hostlers
jesters144118192jesters
jolters143711992jolters
joshers174111592joshers
jostlers15357682jostlers
jotters143413802jotters
jousters153210422jousters
justers143815732justers
koshers144811802koshers
lasters75627692lasters
listers74026532listers
lobsters10268742lobsters
lofters103912902lofters
loiters74116612loiters
looters74419162looters
losers65123582los_ers
lotters73921062lotters
lusters73921442lusters
masters94628922masters
misters93927512misters
mobsters12359062mobsters
molters93816972molters
monsters103314552monsters
mooters93818622mooters
moshers124017842moshers
mossers94116192mossers
musters94522512musters
nesters74422792nesters
noshers103614332noshers
noters64021002no_ters
oaters65029792_oaters
osiers63412792_osiers
ostlers72911202_ostlers
otters64021512_otters
ousters74122792ousters
outers64230172_outers
oxters134813272_oxters
oysters103411692oysters
pasters94531732pasters
pesters93827092pesters
porters93722702porters
posers84223972pos_ers
poster84129172poster_
postern93615612postern
posterns102713722posterns
potters94024342potters
pouters94221872pouters
powters124015662powters
rasters74629022rasters
resters74130402resters
roasters83615932roasters
roisters83615552roisters
roosters83514662roosters
rooters74522932rooters
roster64329082roster_
rotters74421392rotters
rousters84315682rousters
routers74822872routers
roysters113610532roysters
sisters73721592sisters
sorters74221132sorters
souters74422602souters
tasters74225642tasters
testers74124542testers
toasters83912722toasters
tooters73818772tooters
tossers74713502tossers
toters65026362to_ters
totters74618732totters
touters74018352touters
ulsters72711982ulsters
voters95017442vo_ters
wasters104026592wasters
westers105221962westers
xysters17307162xysters
zester153617792zester_
zoners155115992zo_ners

Search took 4 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 Filter1786911076710.356501941.0
2DLD Change Limit1076711233.05035302.0
3Display Results1231230.0462673.9
 (SQL Overall)1786911233.45251764.5
 
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.