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

155 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
ceviches183484(None) 
ceviche1744141ceviche_
seviches1635801seviches
caliches153812272caliches
cervices1537132cervic_es
cliches144213742c_liches
crevices1536712crevic_es
devices133212582devic_es
fetiches1636952fetiches
seiches12513812se_iches
seviche1545112seviche_
advices13136933advic_es
affiches1945233affiches
babiches1735253babiches
beaches144120653be_aches
beeches143413883be_eches
belches143514343be_lches
benches143918603be_nches
bevies114017303bevi__es
bewitches1943823bewitches
caches137926913c__aches
caleches15269943caleches
calices114321693calic_es
caliche14329963caliche_
calicles123811433calicles
calicoes123911603calicoes
capuches1735513capuches
carices114220953caric_es
caroches15710693caroches
catches144320773c_atches
caviares1337993caviares
cavies114525003cavi__es
cavities131412613cavities
cecities12312043cecities
cenacles1238023cenacles
cercises12410933cercises
ceriphs1484753ceriph_s
cerises94722253ceri_ses
cerites94823433ceri_tes
cervixes2054603cervi_xes
cherishes1767563cherishes
chevies153511443chevi__es
chichis1737073c_hichis
chicles143512503c_hicles
chinches18369363chinches
choices142010613choic_es
churches1846433churches
cilices113814023cilic_es
cimices13279803cimic_es
cinches144215773c_inches
civics13397823civic__s
civies114116443civi__es
clavicles1643673clavicles
clenches152910953clenches
clevises1336903clevi_ses
cliche133712453c_liche_
cliched153711023c_liched
clinches153910363clinches
cloches144113713c_loches
clutches15307923clutches
coaches144018693c_oaches
codices12512583codic_es
conches144019813c_onches
cooches143515833c_ooches
corniches1666673corniches
couches144020473c_ouches
cranches153114543cranches
cratches153012543cratches
creches14313093c_reches
crevice1436153crevic_e_
creviced1634453crevic_ed
crotches153411303crotches
crouches153711293crouches
crunches153711353crunches
crutches15359593crutches
cubicles1435883cubicles
cuishes122810823c_uishes
culches143710743c_ulches
culices113713123culic_es
cultches15316533cultches
curches143512743c_urches
cutches143216463c_utches
cuticles1237893cuticles
cylices14359283cylic_es
deices94119373de_ic_es
dervishes1644933dervishes
detaches1439653detaches
deviates12312733deviates
device124512163devic_e_
devisees12358283devisees
devises114116763devi_ses
devoices14307413devoic_es
eches106322163_e__ches
enriches1337263enriches
etches114217763_e_tches
evicted1337243_evicted
evictee1248103_evictee
evictees1344583_evictees
evicts11368553_evic_ts
evinces1237803_evinces
evites94916473_evi_tes
fetches153413893fe_tches
fetishes1437153fetishes
fiches145219533__fiches
helices12313723helic_es
kenches163912273ke_nches
ketches164012193ke_tches
kvetches2053583kvetches
lavishes1457403lavishes
leaches123319343le_aches
leches115421313le__ches
leeches123911933le_eches
letches124015483le_tches
levies93919863levi__es
levities11310713levities
liches114724293__liches
mensches1536303mensches
merches144013763me_rches
miches134320733__miches
niches114419143__niches
novices1238223novic_es
peaches144120053pe_aches
pedicles1338683pedicles
penoches1538933penoches
penuches1536943penuches
perches143717953pe_rches
perishes13313753perishes
potiches1539203potiches
quaiches2235343quaiches
quiches2139333_quiches
ravishes1478043ravishes
reaches123423203re_aches
relishes11311953relishes
retches123318513re_tches
reticles103912483reticles
revanches1746253revanches
reviles104421353revi_les
revises104220533revi_ses
revives134715543revi_ves
revoices13278993revoic_es
riches115022083__riches
searches132112903searches
seiche11811833se_iche_
services1338573servic_es
teaches122718353te_aches
tenches123515523te_nches
vehicles16204683vehicles
vesicles13127073vesicles
vetches153411263ve_tches
vices105725533__vic_es
vichies15310623__vichies
wavicles1633783wavicles
welches153710313we_lches
wenches152914133we_nches
wiches144418753__wiches

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.420425454.8
2DLD Change Limit1461621557.17320376.7
3Display Results1551550.0632460.3
 (SQL Overall)1786911557.65623340.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.