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

164 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
ageisms105660(None) 
ageism968801ageism_
ageists848491ageists
agisms9399391ag_isms
ableisms1245412ableisms
aegises8311372aegises
ageings9437692ageings
ageist7315382ageis_t
agism84614062ag_ism_
agists75713172ag_ists
atheisms1346922atheisms
autisms94311552autisms
deisms94411042_deisms
egoisms1065952egoisms
ogreisms1144112ogreisms
ogrisms1036442ogrisms
seisms84912142_seisms
theisms1237762theisms
ableism1136823ableism_
ableists1036543ableists
abysms13565653a_bysms
adeems946333ade_ems
advises11138973advises
aegis6316783aegi__s
affirms1534383affirms
ageing84213403agei_ng
ageless8310343ageless
agendas936933agendas
agendums1243443agendums
agenes74720253age_nes
ageneses939303ageneses
agenesis938043agenesis
agenizes18269743agenizes
agents74816293age_nts
agers65027853age__rs
ages55844593age___s
aggies83515513aggi_es
agings86312673ag_ings
agios65919863ag_i_os
agist66325583ag_is_t
agitas7310593ag_itas
agnizes17328843agnizes
agonises92613163agonises
agonists9289833agonists
agrias74315393agri_as
aguish1059283aguis_h
aims67738183a__i_ms
algorisms1246173algorisms
alienisms1146703alienisms
allelisms1156003allelisms
alliums957973alliums
amiss75823073a_mis_s
aneurisms1145633aneurisms
animisms12328393animisms
anises64826693a_nises
aorists74215833aorists
arises65233803a_rises
arrises71617583arrises
artists74215593artists
asepses946363asepses
asepsis985903asepsis
aspises9611643aspises
assists738473assists
asterisms11511063asterisms
atavisms1346993atavisms
atheism1248523atheism_
atheists1138713atheists
atomisms12269573atomisms
atriums939043atriums
aurists74615783aurists
autecisms1346033autecisms
autism83815333autism_
autists73814853autists
avenses1049643avenses
avisos95410483a_visos
axioms15408053a_xioms
axises134413993a_xises
baalisms1238033baalisms
baptisms1446033baptisms
bogyisms1643823bogyisms
cambisms1645803cambisms
casteisms1345253casteisms
chemisms17278213chemisms
chrisms1499143chrisms
civisms1436073civisms
cubisms13306883cubisms
dadaisms1245123dadaisms
deism84116033_deism_
deists74916433_deists
egests74411253ege_sts
egises7312493eg_ises
egoism977473egoism_
egoists887073egoists
egotisms1146683egotisms
eonisms92811043eonisms
faddisms15264983faddisms
fascisms1545663fascisms
fauvisms1643743fauvisms
favisms1535443favisms
feists94915313_feists
fideisms1444453fideisms
fogeyisms1843163fogeyisms
fogyisms1743283fogyisms
geests75912163_geests
geisha1035213_geisha
geishas1135083_geishas
gems75329113_ge__ms
genoms94412483_genoms
germs85118873_ge_rms
gests66028813_ge_sts
geums85414113_ge_ums
gismo848863_g_ismo
gismos957183_g_ismos
gists66026193_g_ists
glims87417673_gli_ms
gneiss765953gneis_s
grists74716483_grists
guises74216313_guises
haggises1335883haggises
heists96814633_heists
holisms123811113holisms
hygeists1543543hygeists
imagisms1344903imag_isms
iodisms10308483iodisms
isms66213473___isms
jisms14458003__jisms
laicisms1247123laicisms
legists899593legists
lyrisms1235653lyrisms
magnetisms15576693magnetisms
momisms10308223momisms
monisms113512803monisms
mutisms11338453mutisms
nanisms938833nanisms
narcisms1267263narcisms
nomisms11268743nomisms
nudisms10305853nudisms
obelisms1236393obelisms
obiisms1135673obiisms
ogreism1044233ogreism_
ogrism937913ogrism_
paganisms1447933paganisms
papisms13238543papisms
parecisms1547163parecisms
peises84125043_peises
pietisms1247463pietisms
plenisms1237963plenisms
porisms113713453porisms
prisms104915503_prisms
purisms114110833purisms
racemisms1544253racemisms
racisms112310813racisms
sadisms10359113sadisms
schisms1437173schisms
seises64026713_seises
seism75019023_seism_
sexisms16226223sexisms
speises93813933speises
speiss84311643speis_s
tachisms1567143tachisms
theism1139483theism_
theists1039153theists
truisms9106823truisms
verisms123011253verisms

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.403443402.0
2DLD Change Limit1340271646.04622167.9
3Display Results1641640.0632603.2
 (SQL Overall)1786911646.51227440.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.