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 “vehicles” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

99 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
vehicles1620468(None) 
vehicle15175251vehicle_
vesicles13127071vesicles
chicles143512502_chicles
pedicles1338682pedicles
reticles103912482reticles
vernicles1446132vernicles
versicles1446352versicles
vesicle12217922vesicle_
aediles83413903aedi_les
articles10310243articles
auricles10138333auricles
bernicles1345403bernicles
calicles123811433calicles
cenacles1238023cenacles
ceviches1834843ceviches
chicle134312543_chicle_
chiles115425303_chi_les
cubicles1435883cubicles
cuticles1237893cuticles
debacles1335723debacles
deciles104417723deci_les
defiles114016843defi_les
dehisces1464713dehisces
deices94119373de_ic_es
denticles1237753denticles
devices133212583devic_es
edibles1048003_edibles
ediles74016983_edi_les
enisles72312603_enisles
exiles134816403_exi_les
fetiales11319613fetiales
fetiches1636953fetiches
funicles13246833funicles
helices12313723helic_es
icicles1135943_icicles
ossicles1054183ossicles
panicles121010113panicles
pedicels1336253pedicels
pedicle1238973pedicle_
pedicled1436463pedicled
pellicles1344923pellicles
petioles10311643petioles
radicles11249703radicles
recircles1344433recircles
recycles1535353recycles
refiles104122423refi_les
rehinges1248403rehinges
rehires105016113rehi_res
resiles74026543resi_les
reticle94112623reticle_
reticules1139013reticules
retiles74426993reti_les
retitles83612593retitles
reviles104421353revi_les
sanicles10149943sanicles
seiches12513813se_iches
seniles72618023seni_les
seviches1635803seviches
silicles1037073silicles
testicles1146773testicles
tunicles10217133tunicles
utricles1037223utricles
vahines133410523vahi_nes
varices123313573varic_es
varioles11711123varioles
vegies104314273vegi__es
vehicular1744283vehicular
veiled103714543ve_i_led
veiler93814353ve_i_ler
veilers103911823ve_i_lers
veils84918803ve_i_l_s
veinless11136263ve_inless
veinlet101310573ve_inlet
veinlets11144833ve_inlets
veinules1135913veinules
velites103417303veli_tes
vendibles15164583vendibles
venines103516613veni_nes
venires103012453veni_res
ventricles1544523ventricles
venules104011483ve_nules
verbiles1338923verbiles
verifies141313483verifies
verites103822263veri_tes
verities111418043verities
vernacles1445073vernacles
vernicle1346433vernicle_
versicle1366583versicle_
vertices13612283vertic_es
vesicae12177703vesicae_
vesicates14119033vesicates
vetches153411263ve_tches
vexils1647173vexi_l_s
vices105725533v__ic_es
voices114414013v_oic_es
voiles94616443v_oi_les
wavicles1633783wavicles
whiles124418013_whi_les

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.1561145455.1
2DLD Change Limit146162997.45319611.2
3Display Results99990.0333000.0
 (SQL Overall)178691997.64223382.8
 
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.