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

245 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
nanisms93883(None) 
nanism8311201nanism_
onanisms1048061onanisms
agisms9399392_agisms
anises64826692_anises
eonisms92811042eonisms
favisms1535442favisms
monisms113512802monisms
narcisms1267262narcisms
nomisms11268742nomisms
nudisms10305852nudisms
onanism9310132onanism_
onanists838412onanists
papisms13238542papisms
pianisms1249012pianisms
racisms112310812racisms
sadisms10359112sadisms
tanists7313652tanists
uranisms1099972uranisms
abysms13565653_abysms
ageisms1056603ageisms
agism84614063_agism_
agists75713173_agists
aims67738183_a_i_ms
amiss75823073_amis_s
angsts738863_angsts
anils56326723_ani_ls
anima74620073_ani_ma
animas84418723_animas
anime75423203_ani_me
animes84719593_animes
animi74016663_ani_mi
animis84615943_animis
animisms12328393animisms
animus84211613_animus
anions64123033_anions
anis45746463_ani__s
anise55129703_anis_e
anisic8313793_anisic
anuses66218773_anuses
arises65233803_arises
atavisms1346993atavisms
autisms94311553autisms
avisos95410483_avisos
axioms15408053_axioms
axises134413993_axises
baalisms1238033baalisms
banians9312033banians
banish111416043banis_h
banishes131812463banishes
bantams1149063bantams
baptisms1446033baptisms
bariums1139143bariums
binarisms1346413binarisms
cambisms1645803cambisms
camisas113411923camisas
camises114218463camises
canids95118133cani_ds
canines93724033canines
cansos84915383can_sos
charisms15710263charisms
chrisms1499143chrisms
civisms1436073civisms
cladisms1336093cladisms
clonisms1237793clonisms
coniums11311863coniums
craniums1297913craniums
cubisms13306883cubisms
czarisms2155753czarisms
dadaisms1245123dadaisms
daises74318983da_ises
dandyisms1643223dandyisms
danios7314603dani_os
danish101513793danis_h
danishes121710493danishes
deisms94411043_deisms
denims95214323deni_ms
dualisms1147213dualisms
dynamisms1743373dynamisms
egoisms1065953egoisms
eonism83213533eonism_
etatisms1038293etatisms
faddisms15264983faddisms
fandoms13229473fandoms
fanions103713073fanions
fantasms1345633fantasms
fantoms12189153fantoms
fanums1137263fan_ums
fascisms1545663fascisms
fauvisms1643743fauvisms
favism1437913favism_
finalisms14318833finalisms
finises10312903finises
giantisms1244813giantisms
hafniums1643103hafniums
hahniums1643343hahniums
hakims1537303haki_ms
hansas94616043han_sas
hanses95022633han_ses
hansoms12238523hansoms
holisms123811113holisms
humanisms1646683humanisms
imagisms1344903imagisms
iodisms10308483iodisms
ionises72916433ionises
ioniums938303ioniums
isms66213473___isms
jisms14458003__jisms
kaliums1336603kaliums
kyanises15206393kyanises
laconisms1347013laconisms
laicisms1247123laicisms
lapises93513463lapises
lyrisms1235653lyrisms
maims96321793ma_i_ms
maists85817573ma_ists
maniacs114313063maniacs
manias84029033mani_as
manics103919933mani_cs
manilas93915873manilas
maniocs113611443maniocs
manitos9314053manitos
manitus9310923manitus
manses84225513man_ses
mantises10317923mantises
mavises122812993mavises
maxims17399673maxi_ms
melanisms1348653melanisms
minims104514813mini_ms
miniums113910223miniums
momisms10308223momisms
monadisms1446253monadisms
monism104016313monism_
monists93614783monists
mutisms11338453mutisms
nabis76020583nabi__s
nabobisms1543693nabobisms
nadirs7109003nadi_rs
naiads739013na_iads
naifs87617423na_i_fs
nails55730403na_i_ls
nairas6312783na_iras
nairus639143na_irus
naives94914223na_ives
nanas55928633nan__as
nances83618643nan_ces
nancies93516843nancies
nandinas936573nandinas
nandins8312003nandins
nankins1159053nankins
nannies73015203nannies
nans46139403nan___s
napalms1144033napalms
narcism1188733narcism_
narcists1078113narcists
naris55735293nari__s
nasalisms1147173nasalisms
nasions73112383nasions
nations74720563nations
natives10310823natives
nativisms14105993nativisms
natriums1046293natriums
naturisms1146703naturisms
navies95218623navi_es
nazis145216083nazi__s
nims66226883__ni_ms
nisus56014393__nisus
noises65021853n_oises
nomadisms1445163nomadisms
nomism103010953nomism_
noncoms1139203noncoms
nonuses73313863nonuses
nudism9357913nudism_
nudists8356833nudists
obiisms1135673obiisms
ogrisms1036443ogrisms
onanist7314633onanis_t
oralisms10610973oralisms
organisms1247213organisms
paeanisms1347583paeanisms
paganisms1447933paganisms
paisas84317493pa_isas
panics103815363pani_cs
panicums1444743panicums
paniers94717333paniers
pansies94521983pansies
papism122211513papism_
papists112110453papists
parises94827183parises
pavises125315493pavises
paynims1434973payni_ms
penises9318193penises
peonisms1238443peonisms
pianism11611033pianism_
pianists1049013pianists
plenisms1237963plenisms
porisms113713453porisms
prisms104915503_prisms
purisms114110833purisms
racism103214193racism_
racists92613323racists
radiums10299313radiums
raises64826543ra_ises
randoms102112433randoms
ranids75118703rani_ds
ranis55235833rani__s
ransoms92410163ransoms
rapists92510753rapists
realisms102212163realisms
sadism94113493sadism_
sadists83310853sadists
sanies63031953sani_es
sanious7514103sanious
santims9312603santims
satanisms1148143satanisms
schisms1437173schisms
seisms84912143_seisms
sexisms16226223sexisms
sinapisms1344793sinapisms
statisms1039543statisms
tachisms1567143tachisms
tamises92715973tamises
tandems1037633tandems
tanist6324593tanis_t
tansies74521243tansies
tantrisms1146323tantrisms
tapises92914013tapises
theisms1237763theisms
titanisms1147423titanisms
truisms9106823truisms
tsarisms1056653tsarisms
tzarisms1965213tzarisms
unionisms1145883unionisms
uranism91112513uranism_
uraniums10117163uraniums
urbanisms13115993urbanisms
valises103516263valises
vanish121513213vanis_h
vanishes141610753vanishes
veganisms1545413veganisms
verisms123011253verisms
waists97415453wa_ists
wanions104011373wanions
womanisms1646893womanisms
zanies153219673zani_es

Search took 10 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.1561145455.1
2DLD Change Limit1340272458.87315105.0
3Display Results2452450.1731416.2
 (SQL Overall)1786912459.20219418.7
 
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.