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

189 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
wanters10442009(None) 
banters94623111banters
canters94827731canters
ranters73323641ranters
wafters134112811wafters
waiters104218621waiters
wanders114221331wanders
wankers144514711wankers
wanter94423051wanter_
wasters104026591wasters
waters95030631wa_ters
winters103720481winters
afters94717072_afters
alters64924222_alters
angers75222542_angers
antes56334322_ante_s
anthers103715202_anthers
antlers74014742_antlers
antres65021002_antres
asters65631602_asters
awaiters1146642awaiters
baiters94619302baiters
banders104324562banders
bangers104020352bangers
bankers133919092bankers
banners94018712banners
banter84825332banter_
barters94223032barters
basters94930302basters
batters94626012batters
bunters94717122bunters
cancers114018582cancers
caners84629202can_ers
cankers134418752cankers
canners93822662canners
canoers94318372canoers
canter85230112canter_
cantors94620752cantors
carters95327252carters
casters94729902casters
caters85336502ca_ters
centers94420602centers
chanters134016742chanters
dancers103413092dancers
danders93921182danders
dangers94818212dangers
darters84017602darters
daters74827372da_ters
daunters9329852daunters
easters75125682easters
eaters65535952ea_ters
enters64425642_enters
fainters11349692fainters
falters103916472falters
fanners103914652fanners
gaiters83516542gaiters
ganders93521702ganders
gangers94418602gangers
garters84218232garters
gasters85624292gasters
gaters74728642ga_ters
granters93614142granters
hafters134614332hafters
halters104619802halters
handers114224332handers
hangers113120812hangers
hankers144218132hankers
haters94930402ha_ters
hatters104221522hatters
haunters11329542haunters
hinters103719582hinters
hunters103915732hunters
inters64328052_inters
kantars11310032kantars
lancers93616642lancers
landers84026212landers
lanners73618332lanners
lantern7310012lantern
lanterns838302lanterns
lasters75627692lasters
linters73822632linters
mangers103521262mangers
manners93417832manners
mantels94515042mantels
mantes84430782mante_s
masters94628922masters
maters85032392ma_ters
matters94421752matters
minters93822472minters
natters73718062natters
oaters65029792oa_ters
painters103013022painters
palters94021682palters
panders103423732panders
paniers94717332paniers
panners93621272panners
panthers13510782panthers
panzers184012012panzers
pasters94531732pasters
paters84935832pa_ters
patters94825192patters
planters102915322planters
punters93617042punters
rafters103715632rafters
rangers83621042rangers
rankers113217462rankers
ranter63826822ranter_
rasters74629022rasters
raters63936582ra_ters
ratters74422472ratters
renters74224812renters
salters73622252salters
sanders84025942sanders
sangers84421942sangers
santera7311302santera
santeras8311062santeras
santero7311132santero
santeros8311192santeros
santirs7312962santirs
santurs7310762santurs
saunters82911752saunters
sinters74024082sinters
swatters113911792swatters
tankers113416912tankers
tanners74018392tanners
tasters74225642tasters
taters64932202ta_ters
tatters74520482tatters
taunters8259272taunters
tenters73921102tenters
tinters74221112tinters
twangers12226062twangers
vanners103612842vanners
vaunters11327752vaunters
venters103717732venters
wadders123812442wadders
waders109120642wa_ders
wafers124316142wa_fers
wafter124114612wafter_
wagers105122202wa_gers
waggers124613082waggers
wailers103916802wailers
waisters113811522waisters
waiter94321252waiter_
waivers133410052waivers
wakers134822492wa_kers
walers94824462wa_lers
walkers143411472walkers
waltzers2034002waltzers
wander104423712wander_
wanes85040882wan_e_s
wanglers123310032wanglers
wanier93920682wanier_
wanker134219972wanker_
wanner94019622wanner_
wanness102610682wanness
wanted104319722wante_d
wantoners12116672wantoners
wantons103713012wantons
wants87932212want__s
warders113416812warders
warmers124514292warmers
warners103315562warners
warpers123413582warpers
washers134517522washers
waster95228942waster_
wastery134610992wastery
wastes96224882waste_s
water84733312wa_ter_
watery123914492wa_tery
watter93221982watter_
wavers125022472wa_vers
waxers164014302wa_xers
weaners104613832wean_ers
welters103516062welters
westers105221962westers
wetters103817752wetters
wincers123415362wincers
winders113721262winders
wingers113921482wingers
winkers143517112winkers
winners104316912winners
winter94222802winter_
wintery13399752wintery
wonders113315992wonders
wonners104312812wonners
writers105513492writers
yatters103914622yatters
zanders173015792zanders

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.403443402.0
2DLD Change Limit1076711893.34632179.0
3Display Results1891890.0603150.0
 (SQL Overall)1786911893.80946912.8
 
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.