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

164 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
weevils138468(None) 
weevil1295431weevil_
weevily1694641weevily
bedevils1444372bedevils
devils104412812_devils
ervils948772_ervils
evils84114262__evils
kevils13358332_kevils
weedily1476122weedily
weenies102915092weenies
weepies122811742weepies
weevers13379992weevers
weeviled1533142weeviled
weevilly1782622weevilly
alevins102110573alevins
anvils9219713_anvils
bedevil1344513bedevil_
beedies10314203beedies
beefily1535613beefily
beeves114615043beev_es
bevels113913983_bevels
bevies114017303_bevies
bewails1277553bewails
bezils1711310603_bezils
cavils114014393_cavils
ceils75019403_ce_ils
chervils1644553chervils
chevies153511443chevies
clevis1158963clevi_s
coevals1237873coevals
deils65722863_de_ils
dentils84115583dentils
derails84216393derails
details84214043details
deveins1138813deveins
devels104313903_devels
devil94714733_devil_
eels46536743_ee__ls
eerily92913563_eerily
emails84412343_emails
envies9314053_envies
ervil8310303_ervil_
evil75318073__evil_
feels85223043fee__ls
gerbils1037303gerbils
heavies132713873heavies
heavily1665903heavily
heels85625533hee__ls
heils85222193_he_ils
jezails2334163jezails
keels94622413kee__ls
keeves133711993keev_es
kelvins14106563kelvins
kevels134410713_kevels
kevil12399863_kevil_
leerily1037633leerily
lentils73912973lentils
levels94113283_levels
levies93919863_levies
levins94514653_levins
levis85818553_levi_s
needily1166323needily
nervily1336863nervily
peavies122213403peavies
peels75226423pee__ls
peepuls1134923peepuls
peeries93623023peeries
peeves113814873peev_es
peeving135112243peeving
peevish1535783peevish
peewits12105873peewits
pelvics14245643pelvics
pelvis113610323pelvi_s
pencils113011773pencils
pensils92811593pensils
perils84121853_perils
prevails1337663prevails
reavails1134853reavails
reboils94111723reboils
recoils93814873recoils
reedily1179613reedily
reedits8511743reedits
reels55333263ree__ls
reemits9611303reemits
reeves94721493reev_es
reeving113717663reeving
remails94714563remails
renails74917263renails
reoils64516873_reoils
resails74616743resails
retails74718973retails
reveals103812723reveals
revels94220573_revels
revile94921613_revile
reviles104421353_reviles
seedily1178583seedily
seels55632823see__ls
serails73318363serails
servals103410743servals
servile10310643servile
speils84116223spe_ils
sweenies11148763sweenies
sweeties11159723sweeties
teels55726373tee__ls
tenails73713923tenails
tweenies11146393tweenies
unveils1045753unveils
veeries102916893veeries
veils84918803_ve_ils
vexils1647173_vexils
wails86631483w__ails
wavies125019843w_avies
wavily15219483w_avily
weals85428743w_e_als
wearies103020223wearies
wearily1338783wearily
weasels10468503weasels
weavers133714463weavers
weaves123616373weav_es
weaving143211623weaving
wedels103811033w_edels
wedgies123910213wedgies
weeders113412933weeders
weedier113810623weedier
weediest122311133weediest
weeding123815213weeding
weeds95222213wee__ds
weeklies1534913weeklies
weekly1635313wee_kly
weeks125017863wee__ks
weel75834083wee__l_
weenie92612023weeni_e
weenier103210803weenier
weeniest112411213weeniest
weening114113973weening
weens85224053wee__ns
weepers123511973weepers
weepie11258793weepi_e
weepier12319273weepier
weepiest13219473weepiest
weeping133613673weeping
weepings14346483weepings
weeps104120563wee__ps
wees76249123wee___s
weeting113816053weeting
weets85427723wee__ts
weever123811443weev_er
weewees1336563weewees
weirs84316493w_e_irs
welkins1437173welkins
wellies103719073wellies
wells85426193w_e_lls
weregild1342823weregild
weregilds1441623weregilds
wergild1234043wergild
wergilds1342653wergilds
weskits1434743weskits
wheals124512523whe_als
wheelies1437863wheelies
wheels123811713whe_els
wheezily2642303wheezily
wienies102213683wienies
wormils1236733wormils
yeelins1038813yeelins

Search took 7 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.390458182.1
2DLD Change Limit1340271645.84322938.0
3Display Results1641640.0632603.2
 (SQL Overall)1786911646.29628381.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.