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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

251 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
waltzers203400(None) 
waltzer1934381waltzer_
waltzes1935951waltze_s
alters64924222_alt_ers
falters103916472falt_ers
halters104619802halt_ers
palters94021682palt_ers
patzers184210572pa_tzers
salters73622252salt_ers
saltiers83411952saltiers
seltzers1735062seltzers
wafters134112812waft_ers
waiters104218622wait_ers
walers94824462wal__ers
walkers143411472wal_kers
waltzed2033492waltze_d
wanters104420092want_ers
wasters104026592wast_ers
waters95030632wa_t_ers
welters103516062welt_ers
aethers103614943_aethers
afters94717073_aft_ers
alders74218423_al_ders
aliners74717723_aliners
almners9399563_almners
altars64518153_alt_ars
alter54828503_alt_er_
alterers82512493_alterers
altheas1038233_altheas
analyzers21143663analyzers
anthers103715203_anthers
antlers74014743_antlers
asters65631603_ast_ers
awaiters1146643await_ers
baiters94619303bait_ers
balers85626933bal__ers
balkers134915723bal_kers
ballers94421013bal_lers
banters94623113bant_ers
baptizers2243443baptizers
barters94223033bart_ers
basters94930303bast_ers
bathers124720363ba_thers
batters94626013ba_tters
battlers104110973battlers
belters93819413belt_ers
blathers134713793blathers
blatters104414093blatters
blazers184811683_blazers
blitzers19417153blitzers
bolters94017803bolt_ers
calibers1238523calibers
calipers1249443calipers
calkers134414693cal_kers
callers94221963cal_lers
caloyers1337343caloyers
canters94827733cant_ers
carters95327253cart_ers
casters94729903cast_ers
caters85336503ca_t_ers
clatters103313913clatters
colters93522443colt_ers
dalliers93610613dalliers
darters84017603dart_ers
daters74827373da_t_ers
dialyzers2242783dialyzers
easters75125683east_ers
eaters65535953ea_t_ers
elaters74420193elat_ers
exalters1536653exalt_ers
fallers103917993fal_lers
falter94519053falt_er_
falterers12238033falterers
fathers133916503fa_thers
filters103816553filt_ers
flatters113814203flatters
gaiters83516543gait_ers
garters84218233gart_ers
gasters85624293gast_ers
gaters74728643ga_t_ers
gathers114315073ga_thers
gazers164516303ga__zers
glazers174410043_glazers
hafters134614333haft_ers
halers94926913hal__ers
halter94420883halt_er_
haltere103614713halt_ere
halteres113414603halt_eres
haltless11308443haltless
halvers133311423hal_vers
haters94930403ha_t_ers
hatters104221523ha_tters
hazers184615953ha__zers
jazzers22324763ja_zzers
jilters144211963jilt_ers
jolters143711993jolt_ers
kelters113813753kelt_ers
kilters113813603kilt_ers
lasters75627693last_ers
lathers104321883la_thers
malteds10377603malt_eds
maltier93015483maltier_
maltsters1135193maltsters
mamzers20409163ma_mzers
masters94628923mast_ers
maters85032393ma_t_ers
matters94421753ma_tters
mazers173917093ma__zers
melters93918313melt_ers
milters93619093milt_ers
molters93816973molt_ers
natters73718063na_tters
oaters65029793oa_t_ers
palavers1337993palavers
palmers113513623pal_mers
palter84423263palt_er_
palterers11249533palterers
panthers13510783panthers
panzers184012013pa_nzers
partiers103514243partiers
partners102711133partners
partyers13277763partyers
pasters94531733past_ers
paters84935833pa_t_ers
patters94825193pa_tters
patzer173111643pa_tzer_
pelters93720313pelt_ers
platers93924093plat_ers
platters103415283platters
potzers184010543_potzers
psalters10227713psalt_ers
rafters103715633raft_ers
ralliers84010833ralliers
ranters73323643rant_ers
rasters74629023rast_ers
raters63936583ra_t_ers
ratters74422473ra_tters
rattlers83510293rattlers
razers154919613ra__zers
realizers18237933realizers
realters83614043realt_ers
salliers83613343salliers
salter64325083salt_er_
saltern74010653salt_ern
salterns8388903salt_erns
saltier74318633saltier_
salties73725773saltie_s
saltires83112433saltires
saltless8259343saltless
saltness82610243saltness
saluters8319863saluters
salvers103916003sal_vers
seltzer1635213seltzer_
slaters73123733slat_ers
slathers113914783slathers
swathers144512083swa_thers
swatters113911793swa_tters
swelters113110193swelt_ers
talers64628143tal__ers
talkers113513213tal_kers
talliers83711373talliers
tasters74225643tast_ers
taters64932203ta_t_ers
tatters74520483ta_tters
tattlers8369693tattlers
tilters73315953tilt_ers
valuers10328943val_uers
vaulters11206173vault_ers
wabblers15398993wabblers
wadders123812443wa_dders
waddlers13298333waddlers
waders109120643wa__ders
wafers124316143wa__fers
wafflers17306323wafflers
wafter124114613waft_er_
waftures1434853waftures
wagerers12247613wagerers
wagers105122203wa__gers
waggers124613083wa_ggers
wagoners1235473wagoners
wailers103916803wa_ilers
waisters113811523waisters
waiter94321253wait_er_
waitress1135223waitress
waivers133410053wa_ivers
wakeners1535843wakeners
wakers134822493wa__kers
waler84229263wal__er_
wales86142833wal__e_s
walies95324523wal_ie_s
walker133913993wal_ker_
walkovers1942613walkovers
wallets103914833wal_lets
wallies103320743wallie_s
wallopers14136273wallopers
wallowers15127653wallowers
waltz17615473waltz___
waltzing2134263waltzing
wanders114221333wa_nders
wanglers123310033wanglers
wankers144514713wa_nkers
wanter94423053want_er_
wantoners12116673wantoners
warblers13319103warblers
warders113416813wa_rders
warmers124514293wa_rmers
warners103315563wa_rners
warpers123413583wa_rpers
warslers11328073warslers
warstlers12284713warstlers
wartier103413913wartier_
wartless11279923wartless
washers134517523wa_shers
waster95228943wast_er_
wastery134610993wast_ery
wastes96224883wast_e_s
wastrels1136203wastrels
watchers163511793watchers
water84733313wa_t_er_
waterers112312783waterers
watery123914493wa_t_ery
watter93221983wa_tter_
wattles103814073wattle_s
wattless11268723wattless
waverers14318613waverers
wavers125022473wa__vers
waxers164014303wa__xers
waylayers1842943waylayers
weathers143412833weathers
welchers16338053welchers
welders113313413wel_ders
welshers14246813welshers
welter93417383welt_er_
westers105221963west_ers
wethers135214693w_ethers
wetters103817753w_etters
whalers13529703whal__ers
wheezers23265273wheezers
whetters14246653whetters
whitters14359403whitters
whizzers2233423whizzers
wilders113513503wil_ders
willers103517913wil_lers
winters103720483wint_ers
withers134417753w_ithers
wolfers13409633wol_fers
wolvers13349313wol_vers
writers105513493writ_ers
writhers14398983writhers
wuthers133711523w_uthers
yatters103914623ya_tters

Search took 7 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 Filter1786911461620.423422437.4
2DLD Change Limit1461622516.23323449.7
3Display Results2512510.1261992.1
 (SQL Overall)1786912516.78226347.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.