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

109 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
vehicle1517525(None) 
vehicles16204681vehicles
vesicle12217921vesicle
chicle134312542_chicle
pedicle1238972pedicle
reticle94112622reticle
vernicle1346432vernicle
versicle1366582versicle
vesicae12177702vesicae
vesicles13127072vesicles
aedile73716653aedi_le
article9310923article
auricle9139813auricle
awhile1257793awhi_le
bernicle1245443bernicle
calicle113111433calicle
cenacle1139123cenacle
ceviche1744143ceviche
chicles143512503_chicles
chicly16429203_chicly
chile105626893_chi_le
cubicle1337003cubicle
cuticle1138233cuticle
debacle1237443debacle
decile94619213deci_le
defile105216663defi_le
dehisce13104273dehisce
deice84320033de_ic_e
denticle1137773denticle
device124512163devic_e
edible969353_edible
edile64819493_edi_le
enisle63412093_enisle
exile126117653_exi_le
funicle12237483funicle
icicle1036583_icicle
legible1035833legible
meikle1236653me_ikle
ossicle944483ossicle
overidle1248823overidle
panicle11129983panicle
pedicel1237813pedicel
pedicled1436463pedicled
pedicles1338683pedicles
pellicle1245043pellicle
penile82219603peni_le
petiole9311303petiole
radicle103510713radicle
recircle1244433recircle
recycle1445343recycle
refile95122373refi_le
rehinge1148503rehinge
rehire95415863rehi_re
resile64627673resi_le
reticles103912483reticles
reticule1049303reticule
retile65929673reti_le
retitle73913093retitle
revile94921613revi_le
sanicle91210263sanicle
sedile73517233sedi_le
seiche11811833se_iche
senile63420213seni_le
seviche1545113seviche
silicle937753silicle
testicle1037443testicle
tunicle9308033tunicle
utricle937913utricle
vagile10310543vagi_le
vahine123612113vahi_ne
variole10711593variole
vegie94614513vegi__e
vehicular1744283vehicular
veil75523593ve_i_l_
veiled103714543ve_i_led
veiler93814353ve_i_ler
veils84918803ve_i_ls
veinlet101310573ve_inlet
veinule1056243veinule
veloce11310133veloc_e
vendible14156473vendible
venial94218283venial_
venine93718433veni_ne
venire93513693veni_re
ventricle1444383ventricle
venule94411763ve_nule
verbile1249863verbile
verily122616053veri_ly
verite94323443veri_te
vernacle1345583vernacle
vernicles1446133vernicles
versicles1446353versicles
vesica11157913vesic_a
vesical12159813vesical
vesicate131210053vesicate
vesicula1345223vesicula
vesiculae1445203vesiculae
vexil1538963vexi_l_
vexilla1744663vexilla
vexils1647173vexi_ls
vice95732853v__ic_e
vile76139803v__i_le
virile9313433viri_le
visible1236923visible
voice104915323v_oic_e
voile84719723v_oi_le
vomicae1445303vomicae
wavicle1534063wavicle
while115418693_whi_le

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 Filter1786911340270.390458182.1
2DLD Change Limit1340271096.89019452.4
3Display Results1091090.0462369.6
 (SQL Overall)1786911097.32624391.3
 
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.