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

178 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
venomers133670(None) 
venomer1237581venomer_
genomes103611702genome_s
ionomers1038502ionomers
monomers12311032monomers
oenomels1044582oenomels
tenoners858712tenoners
venders113717002ven_ders
veneers103710292ven_eers
venomed1336652venome_d
venomous1345162venomous
venoms114211212venom__s
venters103717732ven_ters
vetoers10359472veto_ers
vomers115614942v__omers
aeronomers1244453aeronomers
agnomens1144893agnomens
annoyers1185033annoyers
avengers1235583aven_gers
becomes132911963become_s
benames112814603bename_s
benchers153611013benchers
benders104021063ben_ders
benomyls1542983benomyls
bloomers12348823bloomers
boomers114115913_boomers
canoers94318373cano_ers
cenotes92814543cenote_s
censers94313903cen_sers
centers94420603cen_ters
centners1057243centners
comers105328083__comers
deboners11268113deboners
decoders122810413decoders
decoyers14287713decoyers
defamers14258523defamers
defoamers15285253defoamers
deformers15266533deformers
deniers84515183den_iers
denotes83817003denote_s
denuders10165873denuders
deposers11359243deposers
dewormers15255193dewormers
elopers95112943_elopers
emmers104013223_e_mmers
emoters94712873_emoters
enamels9128163_enamels
enamors939123_enamors
encoders1137513_encoders
enders74324053_en_ders
endowers1238233_endowers
enjoyers1843883_enjoyers
enrobers10236953_enrobers
enters64425643_en_ters
enviers1036993_enviers
epimers11109493_epimers
eveners10109503even__ers
evokers14386793_evokers
fencers123810623fen_cers
fenders113717263fen_ders
genders93616783gen_ders
genome94312193genome__
genomics1345713genomics
genoms94412483genom__s
gnomes93812973_gnome_s
gomers94116883__gomers
groomers11388483groomers
hemmers143310843he_mmers
homers114821983__homers
honorers1139273honorers
ignorers9215243ignorers
incomers1268593incomers
ionomer939833ionomer_
isomers9310043_isomers
keynoters1642313keynoters
knowers1436353_knowers
lenders84419653len_ders
menacers12279313menacers
menders103818803men_ders
mesomere1247193mesomere
mesomeres1347193mesomeres
metamers1249623metamers
misnomers1346183misnomers
monomer11311893monomer_
namers84517333__namers
newcomers1643103newcomers
nomes74933123__nome_s
noters64021003__noters
oenomel946563oenome_l
oinomels1044513oinomels
omers76923193___omers
overcomers17125783overcomers
penners93414183pen_ners
pensters103012123pensters
prenomens1347083prenomens
ransomers1146873ransomers
reamers94221083re_amers
recovers133511123recovers
reformers14246403reformers
removers13449223removers
renames92418053rename_s
renders83821673ren_ders
renegers9248793renegers
renewers11238183renewers
renters74224823ren_ters
rentiers83311763rentiers
renumbers1344123renumbers
reposers102911603reposers
repowers13288533repowers
resumers1038083resumers
revokers15366753revokers
roomers95416413_roomers
runovers1134473runovers
seamers94719433se_amers
seemers93814333se_emers
senders83022353sen_ders
senores73218113senore_s
senors63620793seno__rs
snorers74313803_snorers
teemers95012903te_emers
telomere1046433telomere
telomeres1146363telomeres
telomes9310533telome_s
tenders83719723ten_ders
tenners74014923ten_ners
tenoner739683tenoner_
tenors63217753teno__rs
tenours72610073teno_urs
tenters73921113ten_ters
termers95414503te_rmers
vanners103612843van_ners
vaporers1336243vaporers
vealers103214293ve_alers
veers84521363ve___ers
veilers103911823ve_ilers
veiners104112523ve_iners
veligers1237023veligers
velours10278083velo_urs
vendees114011453ven_dees
vender103418423ven_der_
vendors113510223ven_dors
vendues11318623vendue_s
veneer94511693ven_eer_
veneerers1244523veneerers
venenes102712133venene_s
venery123710663ven__ery
venges104015153ven_ge_s
venines103516613venine_s
venires103012453venire_s
venom103914863venom___
venoming1436403venoming
venose9310843venose__
venous93713193veno__us
venter94218723ven_ter_
ventless11249053ventless
venturers1245523venturers
ventures11311493ventures
venues95115203ven_ue_s
venules104011483venule_s
venuses103111413venuse_s
vergers114412633ve_rgers
vermes115019143ve_rme_s
verniers11227843verniers
versers103813523ve_rsers
vespers1239033ve_spers
vetivers1435163vetivers
vetoer93410063veto_er_
vetoes92914083veto_e_s
vetters104016323ve_tters
vexers165210403ve__xers
vintners1134573vintners
vitamers1334683vitamers
vocoders1434243vocoders
vomer105517383v__omer_
voters95017443v__oters
vowers124317183v__owers
welcomers1643513welcomers
wenchers16319213wenchers

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 Limit1461621786.95321021.4
3Display Results1781780.0632825.4
 (SQL Overall)1786911787.43624030.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.