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

283 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
ageists84849(None) 
ageisms1056601ageisms
ageist7315381ageist_
agists75713171ag_ists
ableists1036542ableists
aegises8311372aegises
ageings9437692ageings
ageism968802ageis_m
agents74816292age_nts
agisms9399392ag_isms
agist66325582ag_ist_
agonists9289832agonists
aorists74215832aorists
artists74215592artists
assists738472assists
atheists1138712atheists
aurists74615782aurists
autists73814852autists
deists74916432_deists
egests74411252ege_sts
egoists887072egoists
feists94915312_feists
geests75912162_geests
gests66028812_ge_sts
gists66026192_g_ists
grists74716482_grists
heists96814632_heists
hygeists1543542hygeists
legists899592legists
theists1039152theists
abets75621673abe__ts
ableisms1245413ableisms
ableist9311773ableist_
accosts11107993accosts
addicts1176013addicts
adepts9117103ade_pts
adits66523713a_di_ts
adjusts1544513adjusts
admits9411413admi_ts
advises11138973advises
aegis6316783aegi__s
afrits9311903afri_ts
against838383against_
ageing84213403agei_ng
ageless8310343ageless
agemate101210583agemate
agemates111110023agemates
agendas936933agendas
agenes74720253age_nes
ageneses939303ageneses
agenesis938043agenesis
agenizes18269743agenizes
agent65829643age_nt_
agers65027853age__rs
ages55844593age___s
aggies83515513aggi_es
aghast105711373aghast_
agings86312673ag_ings
agios65919863ag_i_os
agism84614063ag_is_m
agisted938203ag_isted
agita6315423ag_i_ta
agitas7310593ag_itas
aglets73915683ag_lets
agnizes17328843agnizes
agonises92613163agonises
agonist82615403agonist_
agonistes10266263agonistes
agrias74315393agri_as
aguish1059283aguis_h
airts55626343a__irts
aits46355533a__i_ts
alerts64418223ale_rts
alienists946913alienists
alist56136783a_list_
altoists848753altoists
ambits103713413ambi_ts
aments85219803ame_nts
amiss75823073a_mis_s
amorists10411333amorists
anenst63514983anenst_
angsts738863a_ngsts
animists103010633animists
anises64826693a_nises
anoints7311063anoints
aorist64827873aorist_
argents84014853arge_nts
arises65233803a_rises
arista6415293a_rista
aristas7413523a_ristas
aristo6414033a_risto
aristos7312373a_ristos
aroints7313133aroints
arrests73312683arrests
arrises71617583arrises
artist64125543artist_
artiste73813693artiste
artistes83213343artistes
asepses946363asepses
asepsis985903asepsis
aspises9611643aspises
assist6314603assist_
atavists1137583atavists
atheisms1346923atheisms
atheist10314063atheist_
atomists102610963atomists
attests7278813attests
audits72814113audi_ts
aurist65027253aurist_
autisms94311553autisms
autist64324943autist_
avenses1049643avenses
averts95715243ave_rts
avisos95410483a_visos
awaits96411953awai_ts
axises134413993a_xises
baptists1236723baptists
bassists1037183bassists
beasts84519723_beasts
bemists113410703bemists
bests75932613_be_sts
breasts939703breasts
cagiest102916433cagiest_
cambists1437023cambists
canoeists1147163canoeists
casuists1036523casuists
chemists152710323chemists
chests114916263che_sts
cists76624533__cists
coexists1735653coexists
crests85218703cre_sts
cubists11359023cubists
dadaists1045583dadaists
degusts936063degusts
deisms94411043_deisms
deist64633593_deist_
delists84414173delists
desists83611723desists
digests93610613dige_sts
duelists966003duelists
easts57530323__easts
egest65222343ege_st_
egesta7428653ege_sta
egises7312493eg_ises
egoisms1065953egoisms
egoist7612283egoist_
egotists937063egotists
elegists9128113elegists
enlists749393enlists
epeeists1044793epeeists
eugenists1046173eugenists
exists134710913_exists
faddists13235543faddists
fascists1336613fascists
fauvists1443843fauvists
feasts95116093_feasts
feints94813873_feints
feist86230073_feist_
feisty12449293_feisty
fests85828043_fe_sts
fideists1245543fideists
fists85527543__fists
foists95413983_foists
fuguists1243693fuguists
gaits65726013_gai_ts
galiots82311323galiots
gasts66628633_g_asts
geest64829623_geest_
geisha1035213_geisha
geishas1135083_geishas
gelts65924613_ge_lts
gemots93712153_gemots
genets75716663_genets
gents65729613_ge_nts
gest56149133_ge_st_
geste65920693_ge_ste
gestes75721393_ge_stes
gets55442483_ge__ts
ghosts10489273_ghosts
gifts96214963_g_ifts
gilts64924263_g_ilts
girts65423623_g_irts
gist56046763_g_ist_
gits55744593_g_i_ts
glints75714213_glints
glosts74513813_glosts
gneiss765953gneis_s
grifts104511683_grifts
griots74713643_griots
grist65529873_grist_
grits65529583_gri_ts
guests74311203_guests
guilts74111233_guilts
guises74216313_guises
gusts65722793_g_usts
hagadists1445073hagadists
haggises1335883haggises
harpists1338103harpists
heist87030913_heist_
hests85829933_he_sts
hists86328373__hists
hoists95516023_hoists
holists104413963holists
hygeist1445793hygeist_
hygieists1642603hygieists
imagists1175113imag_ists
ingests83210983inge_sts
insists739083insists
jests125922453_je_sts
joists134711033_joists
jurists14409123jurists
kists95822113__kists
latests73910313late_sts
leasts64616413_leasts
legist71315253legist_
legits71313003legi_ts
lists56628693__lists
lutists73810273lutists
lyrists1036963lyrists
maists85817573_maists
mists76633903__mists
monists93614783monists
narcists1078113narcists
neist54628443_neist_
nests55728003_ne_sts
nudists8356833nudists
oboists937903oboists
odists749853_odists
ogreisms1144113ogreisms
ogrisms1036443ogrisms
paganists1247643paganists
pageants1136693pageants
palmists12268813palmists
panelists1148343panelists
papists112110453papists
peises84125043_peises
pests75933273_pe_sts
pietists1038323pietists
plenists1038253plenists
prests84021263pre_sts
priests93810863priests
purists94014073purists
querists1736543querists
quests153310353que_sts
racists92613323racists
rapists92510753rapists
reests64618893_reests
relists73817053relists
resists74414923resists
resits64725563_resits
rests54935873_re_sts
sacrists1039563sacrists
sadists83310853sadists
sagest74920263sage_st_
sagiest82617993sagiest_
schists1248543schists
seises64026713_seises
seisms84912143_seisms
sexists14267673sexists
shists96515113_shists
speises93813933speises
speiss84311643speis_s
tachists1348183tachists
tanists7313653tanists
tests56530193_te_sts
theisms1237763theisms
theist9314763theist_
tubists9288323tubists
twists9549753_twists
typists1236173typists
vegetists1344483vegetists
verists103613673verists
versts93914733_versts
vests85325983_ve_sts
vibists1256483vibists
waists97415453_waists
wests85727003_we_sts
whists124613813_whists
wists86728523__wists
wrests95313083wre_sts
wrists95415643_wrists
yeasts96413053_yeasts
zests145419743_ze_sts

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.390458182.1
2DLD Change Limit1340272835.86022871.5
3Display Results2832830.1062669.8
 (SQL Overall)1786912836.35628113.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.