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

82 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
clepe9461738(None) 
cepe84926651c_epe
cleped115114111cleped
clepes104214621clepes
clept95725771clept
crepe95520721crepe
alee46652322ale_e
aleph10311392aleph
bleep95013452bleep
blype12429672blype
cape87242782c_ape
cede74928762c_ede
cee55952702c_e_e
cep75736332c_ep_
cepes94424462c_epes
ceps86125952c_eps
cere66741472c_ere
cete64934782c_ete
chape125221142chape
cheep125416502cheep
clade85821012clade
clap86429042clap_
claps95626182claps
clapt98027172clapt
clave105420152clave
clean75420412clean
clear76219052clear
cleat76335062cleat
cleave114212512cleave
cleek115514912cleek
clef97028182cle_f
clefs106616242clefs
cleft106222852cleft
cleome1039082cleome
clerk115812452clerk
clever114611532clever
clew95520572cle_w
clewed1225113202clewed
clews105516332clews
clime95720892clime
cline76428532cline
clip86924002clip_
clips96018302clips
clipt96324272clipt
clone75728162clone
clop86929892clop_
clops95924852clops
close76425222close
clove105619442clove
cloze165517542cloze
clue65324532cl_ue
clypei1334162clypei
cope86847382c_ope
coupe96023482coupe
crape96128442crape
creep95218102creep
creme94319322creme
creped114115702creped
crepes105419342crepes
crepey135110932crepey
crept95125892crept
crepy124812702crepy
cripe95521142cripe
elope75219342elope
flee76238792fle_e
glebe85016442glebe
glede75517832glede
glee55239062gle_e
lee36068142_le_e
leke85527402_leke
leper74820742_leper
lept66440882_lept
lipe66839732_lipe
lope65941922_lope
plebe95014872plebe
sleep74920182sleep
slept75728102slept
slipe75626132slipe
slope75823562slope
slype105112362slype
ycleped1543392ycleped
yclept1336012yclept

Search took 2 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 Filter178691538000.1101624463.6
2DLD Change Limit53800821.79629955.5
3Display Results82820.0332484.8
 (SQL Overall)178691821.93992156.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.