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 “weevil” 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
weevil129543(None) 
weevils1384681weevils
weevily1694641weevily
bedevil1344512bedevil
devil94714732_devil
ervil8310302_ervil
evil75318072__evil
kevil12399862_kevil
weedily1476122weedily
weel75834082wee__l
weenie92612022weenie
weepie11258792weepie
weever123811442weever
weeviled1533142weeviled
weevilly1782622weevilly
alevin92511513alevin
anvil82712603_anvil
bedevils1444383bedevils
beedi8711663beedi_
beefily1535613beefily
beeves114615043beeves
bevel104517043_bevel
bewail1189583bewail
bezil163812883_bezil
cavil103816493_cavil
ceil65725063_ce_il
cervid1239323cervid
cervix1865163cervix
chervil1534953chervil
civil103411933_civil
clevis1158963clevis
coeval1138893coeval
deasil71110983deasil
deil56231623_de_il
dentil74017883dentil
derail74218813derail
detail74516433detail
devein1039143devein
devel94217123_devel
devils104412813_devils
eel37946843_ee__l
eerie55228533_eerie
eerily92913563_eerily
email74715103_email
ervils948773_ervils
evils84114263__evils
feel75233843fee__l
fervid1337513fervid
gentil74115123gentil
gerbil938343gerbil
heavily1665903heavily
heel75034223hee__l
heil76328933_he_il
jezail2234643jezail
keel85729483kee__l
keeve124512133keev_e
keeves133711993keeves
kelvin13117323kelvin
kevel124213103_kevel
kevils13358333_kevils
leerily1037633leerily
lentil64315393lentil
level84116553_level
levin84816413_levin
levis85818553_levis
naevi867873naevi_
needily1166323needily
nervily1336863nervily
nevi75116423_nevi_
peel65535613pee__l
peepul1035783peepul
peerie83617893peerie
peeve104915253peev_e
peeved124112893peeved
peeves113814873peeves
peeving135112243peeving
peevish1535783peevish
peewit111110903peewit
pelvic13307553pelvic
pelvis113610323pelvis
pencil103712973pencil
pensil83013333pensil
peril75425953_peril
prevail1238243prevail
reavail1035643reavail
reboil83814683reboil
recoil84016723recoil
reedily1179613reedily
reedit7617223reedit
reel45240533ree__l
reemit8717223reemit
reeve84121323reev_e
reeved104118713reeved
reeves94721493reeves
reeving113717663reeving
remail85017123remail
renail65020763renail
reoil55321183_reoil
resail64418733resail
retail65522073retail
reveal94115063reveal
revel84423163_revel
revile94921613_revile
seedily1178583seedily
seel45042983see__l
serail64222673serail
serval93913413serval
servile10310643servile
speil75618643spe_il
sweetie10157873sweetie
teel46335803tee__l
tenail64516113tenail
unveil957343unveil
veil75523593_ve_il
vexil1538963_vexil
waeful1238123waeful
wail75238823w__ail
wavily15219483w_avily
weal75838683w_e_al
wearily1338783wearily
weasel93410523weasel
weave115218533weav_e
weaved133913483weaved
weaver123916613weaver
weaves123616373weaves
weaving143211623weaving
wedel94513963w_edel
wedgie11428373wedgie
wee66760813wee___
weed85637513wee__d
weeded113914873weeded
weeder103315513weeder
weedier113810623weedier
weeding123815213weeding
weeds95222213wee_ds
weedy125115003wee_dy
week116428153wee__k
weekly1635313weekly
weeks125017863wee_ks
ween75835463wee__n
weened104013733weened
weenier103210803weenier
weenies102915093weenies
weening114113973weening
weens85224053wee_ns
weensy12416823weensy
weeny115316163wee_ny
weep95131653wee__p
weeper114313303weeper
weepier12319273weepier
weepies122811743weepies
weeping133613673weeping
weeps104120563wee_ps
weepy134212593wee_py
weer75535093wee__r
wees76249123wee__s
weest85026773wee_st
weet75254153wee__t
weeted103913793weeted
weeting113816053weeting
weets85427723wee_ts
weevers13379993weevers
weewee12310093weewee
weir76019923w_e_ir
welkin1337313welkin
well75832043w_e_ll
wellie92814913wellie
weregild1342823weregild
wergild1234043wergild
weskit1338343weskit
wheal115716183whe_al
wheel115515343whe_el
wheelie1336203wheelie
wheezily2642303wheezily
wienie9229973wienie
woeful1236363woeful
wormil1138043wormil
yeelin939343yeelin

Search took 6 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 Filter1786911127160.390458182.1
2DLD Change Limit1127161785.31321215.1
3Display Results1781780.0632825.4
 (SQL Overall)1786911785.76630990.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.