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

119 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
wavicle153406(None) 
wavicles1633781wavicles
calicle113111432calicle
clavicle1543602clavicle
panicle11129982panicle
radicle103510712radicle
sanicle91210262sanicle
wavily15219482wavi_ly
advice12107883advic_e
agile65122263_agi_le
aisle55223193_a_isle
alible8311973_alible
amice96122873_amic_e
anile54634463_ani_le
article9310923article
auricle9139813auricle
aviate9315203_aviate
avidly13548783_avidly
awhile1257793awhi_le
axile126020513_axi_le
babiche1644573babiche
caliche14329963caliche
calicles123811433calicles
calycle14245833calycle
canticle1239703canticle
cariole9818343cariole
caulicle1245043caulicle
caviare1238373caviare
cavie104621593cavi__e
cavil103816493cavi_l_
caviled1348723cavi_led
caviler1249063cavi_ler
cavilled1436733cavilled
caviller1337063caviller
cavils114014393cavi_ls
ceviche1744143ceviche
chicle134312543_chicle
clavicles1643673clavicles
cubicle1337003cubicle
cuticle1138233cuticle
dariole8711163dariole
device124512163devic_e
facile112514883faci_le
faille93414743fa_ille
fascicle1554633fascicle
funicle12237483funicle
gavial10310083gavial_
gavials1136603gavials
habile11515213habi_le
icicle1036583_icicle
labile8315223labi_le
macle96127003ma__cle
maile75232223ma_i_le
malice104818483malic_e
manacle11310283manacle
manille92613273manille
maniple11249653maniple
mavie104722563mavi__e
novice1138433novic_e
ossicle944483ossicle
panicled13106783panicled
panicles121010113panicles
particle1239533particle
pavise114714803pavi_se
pavisse12546813pavisse
pedicle1238973pedicle
radiale83813523radiale
radicel10278873radicel
radicles11249703radicles
ravine95522223ravi_ne
ravioli1055613ravioli
reticle94112623reticle
revile94921613revi_le
saice75424053sa_ic_e
sanicles10149943sanicles
savable121711863savable
savine94220283savi_ne
seviche1545113seviche
silicle937753silicle
taille63116923ta_ille
tunicle9308033tunicle
utricle937913utricle
vagile10310543vagi_le
variole10711593variole
vehicle15175253vehicle
vesicle12217923vesicle
vice95732853__vic_e
vile76139803__vi_le
wabble133714843wa_bble
wacke145918623wa__cke
wadable13310233wadable
waddle114715303wa_ddle
waffle15369183wa_ffle
waggle113612303wa_ggle
wahine123813013wahi_ne
wail75238823wa_i_l_
wailed104823593wa_i_led
wailer93720323wa_i_ler
wails86631483wa_i_ls
waive114214603wa_i_ve
wale74546433wa___le
wamble134415753wa_mble
wandle105316663wa_ndle
wangle103817503wa_ngle
warble113516603wa_rble
warily122915093wari_ly
warsle93112923wa_rsle
warstle10328013warstle
wattle94314213wa_ttle
wave105234733wav___e
wavelet13310943wav_elet
wavier124613083wavi_er
wavies125019843wavi_es
waviest134513073waviest
waving134018203wavi_ng
waxable1937673waxable
waxily19218413waxi_ly
while115418693w_hi_le
wile75944373w__i_le

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.406440125.6
2DLD Change Limit1340271195.89322743.4
3Display Results1191190.0303966.7
 (SQL Overall)1786911196.32928233.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.