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 “clepes” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

79 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
clepes10421462(None) 
cepes94424461c_epes
clepe94617381clepe_
cleped115114111cleped
crepes105419341crepes
alephs1136532alephs
bleeps10499102bleeps
blypes13357542blypes
capes95441922c_apes
cedes84927332c_edes
cees65941592c_e_es
cepe84926652c_epe_
ceps86125952c_ep_s
ceres75540012c_eres
cetes75731102c_etes
chapes135421872chapes
cheeps135312912cheeps
clades94920462clades
claps95626182clap_s
claves115020062claves
cleans85817052cleans
clears84116562clears
cleats84919312cleats
cleaves124111622cleaves
cleek115514912cle_ek
cleeks125010542cleeks
clefs106616242cle_fs
clefts114610162clefts
cleomes1138812cleomes
clept95725772clep_t
clerks12458842clerks
clever114611532clever
clevis1158962clevis
clewed1225113202clewed
clews105516332cle_ws
climes104720002climes
clines84926042clines
clips96018302clip_s
clones84526562clones
clops95924852clop_s
closes85425592closes
cloves114918822cloves
clozes174915562clozes
clues74623032cl_ues
clypei1334162clypei
clypeus1433242clypeus
copes97747102c_opes
coupes105022522coupes
crapes104727692crapes
creeps104213622creeps
cremes104517992cremes
crepe95520722crepe_
creped114115712creped
crepey135110932crepey
cripes105120872cripes
culexes1636992culexes
cyeses11510122cyeses
elopes85918162elopes
flees85828752fle_es
flexes164512952flexes
glebes95512242glebes
gledes84915132gledes
glees65027592gle_es
ilexes134510252ilexes
lees45455882_le_es
leges64427292_leges
lenes54738522_lenes
leper74820742_leper
lepers84817322_lepers
leses54930812_leses
lexes127225262_lexes
lopes76437342_lopes
plebes104313622plebes
plexes155313542plexes
sleeps83913322sleeps
slipes84921412slipes
slopes84820452slopes
slypes114410482slypes
ycleped1543392ycleped

Search took 4 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 Filter178691825510.356501941.0
2DLD Change Limit82551793.26625275.9
3Display Results79790.0332393.9
 (SQL Overall)178691793.65548889.5
 
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.