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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

131 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
crepes10541934(None) 
cepes94424461c_epes
clepes104214621clepes
crapes104727691crapes
creeps104213621creeps
cremes104517991cremes
crepe95520721crepe_
creped114115701creped
crepey135110931crepey
cripes105120871cripes
arenes64928392arenes
arepas85515702arepas
aretes64425352aretes
bredes94818472bredes
brees75632552bre_es
breves115516422breves
capes95441922c_apes
cedes84927332c_edes
cees65941592c_e_es
cepe84926652c_epe_
ceps86125952c_ep_s
ceres75540012c_eres
certes84623082certes
cetes75731102c_etes
chapes135421872chapes
cheeps135312912cheeps
clepe94617382clepe_
cleped115114112cleped
copes97747102c_opes
coupes105022522coupes
crakes124921812crakes
cranes84330752cranes
crape96128442crape_
craped116120522craped
craps95328642crap_s
crases85532312crases
crates85736062crates
craves115825392craves
crazes174720132crazes
creaks124315962creaks
creams104715252creams
crease85519572crease
creases94020962creases
creates95225202creates
creches14313092creches
credos94612852credos
creds85418772cre_ds
creed85727392cre_ed
creeds94714772creeds
creek114917392cre_ek
creeks124812922creeks
creel75121482cre_el
creels84416942creels
creep95218102cre_ep
creeped12329712creeped
creeper11339982creeper
creepers12318632creepers
creepies1239612creepies
creepy13418802creepy
creese84014332cre_ese
creeses93914622creeses
creesh11328332cre_esh
creme94319322creme_
crenel84213062crenel
crenels93711012crenels
creoles9913322creoles
crepier1139742crepier
crepiest12310382crepiest
crepon1039942crepon
crepons1139322crepons
crept95125892crep_t
crepy124812702crep_y
cress75022832cre_ss
cresses94219812cresses
crests85218702crests
crewed125316562crewed
crewel114310482crewel
crewels12438492crewels
crews105917502cre_ws
cries75438402cr_ies
crimes105521582crimes
cripe95521142cripe_
crises84529432crises
crones84729242crones
crops96125232crop_s
crores86121162crores
croupes114613102croupes
crozes174417662crozes
cruces105117542cruces
crudes96218622crudes
cruses88127712cruses
cruxes154911562cruxes
crypts13397742crypts
cyeses11510122cyeses
drapes95419652drapes
drees65628522dre_es
drupes94912652drupes
frees86131392fre_es
freres94716172freres
grapes95123122grapes
grebes93813612grebes
grees65132472gre_es
gripes94619872gripes
gropes95220402gropes
herpes115517322herpes
kreeps12427412kreeps
krewes1337922krewes
prees75937172pre_es
preps96220692prep_s
prexes154915952prexes
prezes173614692prezes
rapes75740722_rapes
redes65139132_redes
rees45364192_re_es
reges65628792_reges
repeg84015052_repeg
repegs93311942_repegs
repel74921402_repel
repels84318762_repels
repos74725792_repos
repps95114342_repps
reps65937952_rep_s
rexes124526952_rexes
ripes75435772_ripes
ropes75940062_ropes
scrapes116217662scrapes
screes85023972scre_es
trapes85024462trapes
trees55835762tre_es
tripes85324872tripes
tropes84824352tropes

Search took 3 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.406440125.6
2DLD Change Limit825511312.36034979.2
3Display Results1311310.0304366.7
 (SQL Overall)1786911312.79663909.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.