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

236 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
pensions1031169(None) 
pension9412201pension_
pensione1039771pensione
pensiones11410001pensiones
tensions8310221tensions
benisons1037042benisons
cessions1039852cessions
ensigns836352_ensigns
lesions73813872le_sions
mansions1069792mansions
mentions10312892mentions
passions10310582passions
pennons939712pen_nons
pensils92811592pensi_ls
pensioned1246652pensioned
pensioner1146662pensioner
pensioners1245362pensioners
pepsins11310432pepsi_ns
pereions10310852pereions
persons93717012pers_ons
pinions93413602pin_ions
plosions1038022plosions
pulsions1037712pulsions
sessions839722sessions
sponsions1145222sponsions
tension7311802tension_
venisons1136132venisons
versions11310352versions
amnions93710913amn_ions
anions64123033_an_ions
ascensions1244613ascensions
aspersions1246103aspersions
aversions1247053aversions
basions94213953_basions
benison937123benison_
benthons1337973benthons
benzins1838693benzi_ns
benzoins1945573benzoins
bunions92210473bun_ions
censing104215263censi_ng
censors93611843cens_ors
cession939813cession_
consigns1137533consigns
decisions1248383decisions
delusions1037053delusions
dendrons1047393dendrons
dentins83419223denti_ns
derisions1038843derisions
designs9328313de_signs
dimensions1344613dimensions
elisions82210423elisions
elusions82610083elusions
emersions1147283emersions
enations83316903_enations
enjoins1457333_enjoins
ensign737523_ensign_
ensiles72714833_ensiles
envious1037223_envious
environs1144673_environs
envisions1245613_envisions
eosins64419163_eosi_ns
epsilons1044223_epsilons
erasions8310983erasions
erosions8310343erosions
essoins737603_essoins
ethions1038483_ethions
evasions1136543evasions
eversions1238363eversions
expansions1944153expansions
extensions1746133extensions
fanions103713073fan_ions
fenthions1544233fenthions
fenurons1174963fenurons
fermions1336203fermions
fissions1138033fissions
fusions1039153_fusions
gentians937563gentians
hellions11310023hellions
hessians1145053hessians
inions64417003_in_ions
intensions1048403intensions
kelsons1137323kels_ons
lections102413843lections
legions84611783le_gions
lenitions939473lenitions
lensing84015103lensi_ng
lesion64715063le_sion_
lessons73811023le_ssons
mansion9611543mansion_
menazons1945733menazons
mensing103915103mensi_ng
mention9314373mention_
mesons83215843me_s_ons
minions93314623min_ions
missions10311903missions
monsoons1047343monsoons
munnions1035273munnions
nasions73112383_nasions
nelsons738003nels_ons
neustons836833neustons
onions64016433_on_ions
opinions1045933opin_ions
pactions122613503pactions
pansies94521983pansi_es
parsons93516873pars_ons
passion9310883passion_
peascods1344063peascods
pectins112315233pecti_ns
peins76128063pe__i_ns
peising103416763peisi_ng
pekins121812233pe_ki_ns
pelotons1038913pelotons
pencils113011773penci_ls
pending114119773pendi_ng
pengos94612413pen_go_s
penguins1145383penguins
penis75129323pen_i__s
penises9318193pen_ises
penlites10312273penlites
pennies94218813penni_es
pennine93712953penni_ne
pennines103112043pennines
penning103616493penni_ng
pennis84315743penni__s
pennon8310643pen_non_
penpoint1249453penpoint
penpoints1344553penpoints
pensees9311203pens_ees
pensil83013333pensi__l
pensile92713543pensi_le
pensionary1554363pensionary
pensioning1345913pensioning
pensionless1353173pensionless
pensive122610393pensi_ve
penstemons1452363penstemons
pensters103012123pensters
penstock1644073penstock
penstocks1743713penstocks
pentagons1246153pentagons
penurious1145823penurious
peons75327183pe___ons
pepinos1137693pe_pinos
pepsin10310853pepsi_n_
pepsine11310603pepsi_ne
pepsines1239883pepsines
pereion9312053pereion_
pereons92815003pe_reons
perfusions1595333perfusions
perigons11310083perigons
periods10312243pe_riods
perniones1148593perniones
perrons93115483pe_rrons
persimmons1652053persimmons
persists1049183persists
person83517873pers_on_
persona92812453pers_ona
personas102511883pers_onas
pervasions1545663pervasions
pervious1337543pervious
pesos77221623pe_s_o_s
pestos84719083pe_sto_s
petitions11511083petitions
pillions101610923pillions
pinion83815893pin_ion_
pinons86019943pin__ons
pinyons12299003pin_yons
pions75826393p___ions
pistons93016373p_istons
plasmons12217663plasmons
pleustons1144283pleustons
plosion939113plosion_
poisons9310353pois_ons
pontons93315553pon_tons
pontoons10279313pontoons
portions10514413portions
potions93417423p_otions
precisions1449373precisions
prehensions1645943prehensions
prelusions1256373prelusions
prenotions1248293prenotions
pretensions1347083pretensions
preunions1146483preunions
previsions1547733previsions
prions84317783p__rions
prisons9313223pris_ons
pulsion938393pulsion_
punitions1137923punitions
punkins133111113punki_ns
reasons72514943reas_ons
recensions1248483recensions
recisions1139913recisions
regions83613473re_gions
renins64526453ren_i_ns
rennins74013413renni_ns
resigns83910963re_signs
resins64528773re_si_ns
reunions837273reunions
revisions1238593revisions
ronions73313343ron_ions
scansions1145323scansions
seasons72614233seas_ons
sections102714703sections
seisins73614393seisi_ns
seniors73413623sen_iors
sensations1059853sensations
sensing84116953sensi_ng
sensors73514643sens_ors
sensuous845903sensuous
session739763session_
sponsion1045623sponsion_
sponsons1045813spons_ons
suasions838783suasions
suspensions1353843suspensions
telsons739223tels_ons
tendons8311473ten_dons
tenons62916603ten__ons
tenpins9410073tenpi_ns
tensing84616653tensi_ng
tensional946213tensional
tensioned1045613tensioned
tensioner945913tensioner
tensioners1044823tensioners
tensors72712373tens_ors
ternions838813ternions
testons7313563te_stons
torsions839183torsions
unions64216753_un_ions
unisons748423_unisons
venations12311723venations
venins93816703ven_i_ns
venison1036443venison_
version10310923version_
visions10311023_visions
wanions104011373wan_ions
weasons102310583weas_ons
xenons132710483xen__ons

Search took 8 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.420425454.8
2DLD Change Limit1461622367.08020644.4
3Display Results2362360.0932537.6
 (SQL Overall)1786912367.59323533.6
 
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.