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

231 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
zealots163676(None) 
zealot15313471zealot_
zealous1637811zealous
helots95217702he_lots
jealous1438092jealous
merlots92710122merlots
reallots837992reallots
replots93412632replots
teapots939052teapots
zealotry2042302zealotry
zeals145320852zeal__s
allots64019173_allots
aloes54933673__aloes
altos55822953__altos
alts46639903__al_ts
analogs82810453analogs
ballots94116033ballots
beacons11410733beacons
beanos85516513beano_s
beasts84519723bea_sts
beats76042243bea__ts
beauts86015283bea_uts
beclogs1237073beclogs
beknots1335083beknots
bellows124313303bellows
belons84119413be_lons
belows114614183be_lows
belts75931163be_l_ts
besots86415453be_sots
blots75626173__blots
brulots946223brulots
calos74431903_calo_s
cellos84517803cello_s
celoms10412123ce_loms
celts75325783ce_l_ts
chalets122813473chalets
chalot113020133chalot_
chaloth15298603chaloth
clots75627643__clots
coplots11511593coplots
deacons10310393deacons
dealate83617843dealate
dealates92716683dealates
dealers84118613dealers
deals65435343deal__s
dealt65234283deal_t_
decalogs1245633decalogs
delfts10439673de_lfts
delts65731793de_l_ts
deploys1336523deploys
depots94716343de_pots
desalts839573desal_ts
despots10319683despots
dialogs938103dialogs
diglots9299503diglots
drylots1143743drylots
eaglets84111663_eaglets
easts57530323_ea_sts
eats47054873_ea__ts
eclats8313033_eclats
ergots74512373_ergots
escots84211743_escots
etalons739073etalons
exalts13328313exal_ts
fagots1039963_fagots
fealty122910223feal_ty
feasts95116093fea_sts
feats86432753fea__ts
feedlots12144453feedlots
felloes104114383felloes
fellows134212433fellows
felons93615763fe_lons
felts85324543fe_l_ts
galiots82311323_galiots
galoots82410793_galoots
galops94712623_galops
gavots1038113_gavots
gelants82611443gelants
gelatos83111523gelatos
gelts65924613ge_l_ts
gemots93712153ge_mots
giglots9367863giglots
haloes94623863_haloes
halons95720713_halons
halos85230253_halo_s
halts85230103_hal_ts
harlots103413293harlots
healers104319463healers
heals85733463heal__s
health124712143heal_th
healths13478753healths
hearts96218943hea_rts
heats85838403hea__ts
helloes103717473helloes
hellos95321683hello_s
helos84928063he_lo_s
helot85332683he_lot_
heriots10312063heriots
jabots1538883_jabots
jalops15329593_jalops
jealousy1842223jealousy
jellos134714283jello_s
kelts95222633ke_l_ts
leaflets11244813leaflets
lealty92910603leal_ty
leasts64616413lea_sts
lots47652093___lots
magots9312363_magots
maloti8313213_maloti
malts76331753_mal_ts
meadows1337333meadows
mealies92821933mealies
meals75933383meal__s
meats75034053mea__ts
megalops1356123megalops
melilots1046553melilots
mellows123812233mellows
melons84117713me_lons
melts74930103me_l_ts
merlons93311273merlons
merlot83217613merlot_
neats55931903nea__ts
ocelots977233ocelots
palets85122313_palets
peacoats1247833peacoats
peals75235493peal__s
peanuts936993peanuts
peats76140193pea__ts
pedalos10329703pedalo_s
pellets94014783pellets
pelota8612833pe_lota
pelotas9410723pe_lotas
pelts76128813pe_l_ts
peplos101211543peplo_s
petalous1058973petalous
pilots84018873_pilots
plots75025673__plots
preallots1144513preallots
reacts83616603rea_cts
readopts1146493readopts
readouts938903readouts
reales64934123real_es
realest73322433realest
realist73225383realist
realists83014843realists
reality10313573reality
reallot7312133reallot_
realms84913493real_ms
reals55038653real__s
realtor73611353realtor
realtors82811683realtors
realty92713693real_ty
reasons72514943reasons
reavows1335273reavows
reboots93512093reboots
reflets103513153reflets
refloats1156913refloats
reflows13258983reflows
reglets83512983reglets
regloss8218023regloss
reglows11288843reglows
reknots1136783reknots
relets64025673re_lets
replot83818593replot_
replows12329703replows
repots85621003re_pots
respots92912763respots
revolts1038893revolts
rialtos736613rialtos
sabots8314703_sabots
salols64017873_salols
salons63823693_salons
salts55431883_sal_ts
seaboots1047093seaboots
seadogs958643seadogs
sealants82610743sealants
sealers74323553sealers
sealifts1135473sealifts
seals54839703seal__s
seaports1038463seaports
seasons72614233seasons
seats54844343sea__ts
sellouts837493sellouts
sepalous1047523sepalous
sexpots1636293sexpots
shallots11319503shallots
shaloms1288983shaloms
slaloms9106543slaloms
slots54830533__slots
smaltos9408193smaltos
smalts85214893smal_ts
sublots92410913sublots
talons64019443_talons
tarots66422993_tarots
teals56234133teal__s
teapot8416763teapot_
teapoys1235963teapoys
teats55636813tea__ts
teflons1036543teflons
telos55424523te_lo_s
unzealous1842733unzealous
valets93715623_valets
valors93413773_valors
vealers103214293vealers
veals84926193veal__s
veldts10417753ve_ldts
weakons14287803weakons
wealds10459103weal_ds
weals85428743weal__s
wealth12379223weal_th
wealths13365813wealths
weapons12278603weapons
weasons102310583weasons
weblogs1334223weblogs
welts85225193we_l_ts
yeasts96413053yea_sts
yellows13329603yellows
zeal135530333zeal___
zealotries1944353zealotries
zealously2144303zealously
zeatins16311733zeatins
zeolite1638903zeolite
zeolites1738383zeolites
zeroes154314343ze_roes
zeros144918113ze_ro_s
zeroth1837963ze_roth
zests145419743ze__sts
zlote143912943z__lote
zloty17399793z__loty
zlotys18374173z__lotys
zocalos1835393zocalo_s

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 Filter1786911340270.436409841.7
2DLD Change Limit1340272316.08022043.9
3Display Results2312310.0763039.5
 (SQL Overall)1786912316.59227107.3
 
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.