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

224 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
caleches1526994(None) 
caleche14297951caleche_
caliches153812271caliches
acalephes1643222acalephes
caches137926912ca__ches
calashes13310542calashes
calces104420052cal_c_es
calices114321692calic_es
caliche14329962caliche_
calicles123811432calicles
calicoes123911602calicoes
calyces14428802calyc_es
calycles15295692calycles
capuches1735512capuches
caroches15710692caroches
catches144320772ca_tches
catechus1544822catechus
clenches152910952c_lenches
cliches144213742c_liches
cloches144113712c_loches
creches14313092c_reches
culches143710742cul_ches
cultches15316532cultches
fleches153411442_fleches
leches115421312__leches
acalephe1552733acalephe_
acalephs1542993acaleph_s
aches106132293_a__ches
aitches123014363_aitches
alecs76620733_alec__s
alephs1136533_aleph_s
apaches143411843_apaches
arches114822043_a_rches
babiches1735253babiches
baches135426943ba__ches
batches144019613ba_tches
beeches143413883_beeches
belches143514343bel_ches
blanches153311603blanches
bleaches153410673_bleaches
blenches153310763_blenches
bobeches1744483bobeches
breeches15258673breeches
caboched1844043caboched
cache125122483ca__che_
cached145419203ca__ched
cachet134526413ca__chet
cachets145014263ca__chets
cacoethes1643633cacoethes
cadelles1139973cadelles
cadences1338473cadences
cadencies1447323cadencies
calathos1347533calathos
calathus1345033calathus
calcars11312653cal_cars
calcines12314753calcines
calcites12313003calcites
calender1138273calender
calenders1237403calenders
calends1039523cale_nds
calesas9411833cale_sas
calibres1237103calibres
calicle113111433calicle_
calicos113913493calic_os
calipees1247413calipees
caliphs1436753caliph_s
callees94117783cal_lees
calloses10313393calloses
calluses1039323calluses
calories102919563calories
calottes10610083calottes
calques182710193cal_ques
calves115119283cal__ves
calxes154113033cal__xes
calycle14245833calycle_
calyxes19426233cal_yxes
calzones1948763calzones
canchas143212403ca_nchas
capouches1843633capouches
capuche1644433capuche_
capuched1843743capuched
caresses10314063caresses
carices114220953caric_es
caroaches1637793caroaches
caroche1469243caroche_
carroches1665893carroches
caseases10410473caseases
caseates10313713caseates
casefies1339213casefies
caseoses1039293caseoses
casernes103810753casernes
casettes1039653casettes
cashes114729883ca__shes
catcher143115823ca_tcher
catchers153114063ca_tchers
catecheses1743813catecheses
catechesis1743243catechesis
catechin1546813catechin
catechins1646643catechins
catechise1644943catechise
catechises1744913catechises
catechism1844723catechism
catechist1656803catechist
catechizes2644343catechizes
catechol1544613catechol
catechols1655053catechols
catechu1444473catech_u
caulicles1344383caulicles
cayennes1345013cayennes
celeries10316313celeries
celestes10310013celestes
ceviches1834843ceviches
chalehs15268803chale_h_s
chalices15310813chalic_es
chinches18369363chinches
churches1846433churches
cilices113814023cilic_es
cinches144215773c_inches
clachs133511323c_lach_s
clashes124017283c_lashes
cleaves124111623c_leaves
clenched16257763c_lenched
clencher15277973c_lencher
clenchers16276553c_lenchers
cleomes1138813c_leomes
clepes104214623c_le_pes
cliche133712453c_liche_
cliched153711023c_liched
clinches153910363clinches
cloche134312373c_loche_
clothes124513813c_lothes
clutches15307923clutches
coaches144018693c_oaches
coalesces1346043coalesces
coleuses1039723coleuses
conches144019813c_onches
cooches143515833c_ooches
couches144020473c_ouches
cranches153114543cranches
cratches153012543cratches
craunches1655723craunches
creche13310763c_reche_
creeshes1336953creeshes
crotches153411303crotches
crouches153711293crouches
crunches153711353crunches
crutches15359593crutches
culexes1636993cule_xes
culices113713123culic_es
curches143512743c_urches
cutches143216463c_utches
cylices14359283cylic_es
daledhs1232783daledh_s
daleths1135323daleth_s
earaches13411313earaches
eches106322163___eches
faeces114713123fa_ec_es
falces115216003fal_c_es
filches153410723fil_ches
fleche14299303_fleche_
fleeches16287083fleeches
flenches163410533_flenches
fleshes133913273_fleshes
fletches16308853_fletches
galeres83514343gale_res
galettes93111163galettes
galoshes1236913galoshes
ganaches1437433ganaches
gulches13398113gul_ches
halachas16317893halachas
hatches153420273ha_tches
haunches1656963haunches
klatches17157143klatches
laches116528353__laches
larches124416453la_rches
latches123320133la_tches
launches1387903launches
leaches123319343__leaches
leched123716003__leched
lecher113415853__lecher
lechers123313963__lechers
lechwes1535063__lechwes
leeches123911933_leeches
letches124015483__letches
lethes94818083__lethes
liches114724293__liches
lyches144213613__lyches
maches134827233ma__ches
maleates103316343maleates
malices114316623malic_es
manches143818623ma_nches
marches143921173ma_rches
matches143219783ma_tches
mulches143210673mul_ches
naches114622413na__ches
nautches1336083nautches
painches1588913painches
palaces114216463palac_es
palettes103112833palettes
panaches15310293panaches
panoches1548123panoches
parches143720003pa_rches
parfleches2042173parfleches
patches143320383pa_tches
paunches1568173paunches
planches153111863planches
pleaches153210433_pleaches
plenches153110623_plenches
ranches123620113ra_nches
ratches123620463ra_tches
raunches1368053raunches
samechs14285353samech_s
scoleces1237083scolec_es
screeches1695653screeches
sculches15176273scul_ches
scultches1664293scultches
slatches131511533slatches
speeches1537413speeches
taches114224173ta__ches
valences1388513valences
valencies1446413valencies
watches153017373wa_tches
welches153710313wel_ches
zilches21326303zil_ches

Search took 9 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.423422437.4
2DLD Change Limit1461622247.54619369.5
3Display Results2242240.0932408.6
 (SQL Overall)1786912248.06222164.6
 
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.