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

123 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
venisons113613(None) 
benisons1037041benisons
venison1036441venison_
benison937122benison_
pensions10311692pensions
tensions8310222tensions
unisons748422_unisons
venins93816702veni__ns
versions11310352versions
amnions93710913amni_ons
anions64123033_ani_ons
aversions1247053aversions
benthons1337973benthons
bisons83914373__bisons
bunions92210473buni_ons
censors93611843cen_sors
cessions1039853cessions
decisions1248383decisions
dendrons1047393dendrons
denizens1835573denizens
derisions1038843derisions
devisors12347253devisors
eikons1038503_e_ikons
elisions82210423_elisions
enisles72312603_enisles
ensigns836353_ensigns
environs1144673_environs
envisions1245613_envisions
epigons1048183_epigons
evasions1136543evasions
evensong1242653even_song
evensongs1341393even_songs
eversions1238363eversions
fanions103713073fani_ons
fenurons1174963fenurons
foisons1047613_foisons
genitors937423genitors
grisons838993_grisons
helicons1337613helicons
inions64417003_ini_ons
jettisons1642233jettisons
keelsons1244093keelsons
kelsons1137323ke_lsons
legions84611783legi_ons
lenitions939473lenitions
lesions73813873lesi_ons
lessons73811023le_ssons
lewissons1241743lewissons
lexicons1743893lexicons
liaisons844293liaisons
malisons1048783malisons
mansions1069793mansions
menazons1945733menazons
meniscus1243783meniscus
mentions10312893mentions
mesons83215843me__sons
minions93314623mini_ons
nelsons738003ne_lsons
ninons64913773__ninons
nitons64614903__nitons
onions64016433_oni_ons
orisons7310563_orisons
penises9318193penis_es
pennons939713pen_nons
pension9412203pension_
pensione1039773pensione
pensiones11410003pensiones
perigons11310083perigons
persons93717013pe_rsons
pinions93413603pini_ons
poisons9310353_poisons
prisons9313223_prisons
reasons72514943re_asons
recisions1139913recisions
regions83613473regi_ons
renins64526453reni__ns
reunions837273reuni_ons
revisions1238593revisions
revisors11379063revisors
ronions73313343roni_ons
seasons72614233se_asons
seisins73614393se_isins
seisors73212843se_isors
seniors73413623seni_ors
sensors73514643sen_sors
sessions839723sessions
telsons739223te_lsons
tendons8311473ten_dons
tenons62916603ten__ons
tension7311803tension_
tensors72712373ten_sors
ternions838813terni_ons
unions64216753_uni_ons
unison649033_unison_
vanishes141610753vanishes
veins84620493ve_i__ns
veinstone1253853veinstone
veinstones1363733veinstones
venations12311723venations
venditions1445523venditions
vendors113510223ven_dors
venin85118663veni__n_
venine93718433veni__ne
venines103516613veni_nes
venires103012453veni_res
venomous1345163venomous
venoms114211213ven__oms
venous93713193ven__ous
venulous1145713venulous
venuses103111413venus_es
verismos13284693verismos
verisms123011253veris_ms
verists103613673veris_ts
version10310923version_
versos93812803ve_rso_s
vidicons1443863vidicons
virions1039873viri_ons
visions10311023v__isions
visors92912223v__isors
wanions104011373wani_ons
warisons1136903warisons
weasons102310583we_asons
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.436409841.7
2DLD Change Limit1461621236.86021306.4
3Display Results1231230.0502460.0
 (SQL Overall)1786911237.34624324.9
 
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.