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

86 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
curricle1214593(None) 
curricles13105421curricles
auricle9139812au_ricle
carriole1089862carriole
cornicle1258782cornicle
cubicle1337002cu_bicle
curlicue1243222curlicue
curricula13123712curricula
currie84317262curri__e
cuticle1138232cu_ticle
scurrile1055072scurri_le
utricle937912_utricle
article9310923_article
auricled11135703au_ricled
auricles10138333au_ricles
bernicle1245443bernicle
cabriole1276933cabriole
calicle113111433c_alicle
canticle1239703canticle
caprice1349683capric_e
capriole1276913capriole
cariole9818343c_ariole
carriage1137853carriage
carrioles1169473carrioles
caruncle1244713caruncle
caulicle1245043caulicle
chicle134312543c__hicle
chronicle1644233chronicle
circle1039703c_ir_cle
clavicle1543603clavicle
coracle112011723c_oracle
cornice11612933cornic_e
corniche1575923corniche
cornicles1368243cornicles
corrie83621223corri__e
crucible1445193crucible
cubicles1435883cu_bicles
cubicly1644993cu_bicly
cupric1249123cupric__
cuprite1159683cupri_te
curable112414513cu_rable
curarine10610713curari_ne
curarize1988853curari_ze
curbable1447663curbable
curdle95514313cu_r_dle
curiae84518373cu_ri_ae
curial84019153cu_rial_
curie74533043cu_ri__e
curite85222943cu_ri_te
curlicued1442133curlicued
curlicues1343343curlicues
curlily1238383curli_ly
curlycue1541323curlycue
currach1446453currac_h
currachs1544543currachs
curricular14124153curricular
curriculum1652033curriculum
curried103313653curri_ed
currier93316703curri_er
curriers103410753curriers
curriery13326163curriery
curries93723163curri_es
curring103616843curri_ng
currish1238353curri_sh
currishly1763943currishly
cursive1237833cursi_ve
curule83614123cu_r_ule
cuticles1237893cu_ticles
durrie73713263durri__e
funicle12237483fu_nicle
furrily1337613furri_ly
furuncle1342153furuncle
horrible13135233horrible
hurricane1443133hurricane
murrine9411483murri_ne
orrice81410163_orric_e
particle1239533particle
puerile9310093pueri_le
scurril945113scurri_l_
surtitle845283surtitle
terrible1046643terrible
tunicle9308033tu_nicle
turrical1046203turrical
utricles1037223_utricles
vernicle1346433vernicle
versicle1366583versicle

Search took 10 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.453394461.4
2DLD Change Limit146162868.75016704.2
3Display Results86860.0461869.6
 (SQL Overall)178691869.24919320.0
 
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.