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

115 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
cedis8431708(None) 
cadis84428501cadis
cedes84927331cedes
cedi74919271cedi_
acedia9310392acedia
acedias1039772acedias
aedes64625152aedes
aegis6316782aegis
bedim10313832bedim
bedims1149592bedims
beds75937782bed_s
bidis86721142bidis
caddis104613382caddis
cades85440732cades
cadi75732182cadi_
cads76144522cad_s
caids85226422caids
cebid104314072cebid
cebids11439172cebids
cedar84014322cedar
cedars93312832cedars
cede74928772ced_e
ceded96118562ceded
ceder85322242ceder
ceders93817672ceders
ceding104014802ceding
cees65941592ce_es
ceil65725062ce_il
ceilis85413742ceilis
ceils75019402ceils
cells75428062cells
cels65534972ce_ls
celts75325782celts
cents74730332cents
cepes94424462cepes
ceps86125952ce_ps
cercis104614492cercis
ceres75540012ceres
ceria75125352ceria
cerias83321982cerias
ceric94023092ceric
cerise84822042cerise
ceros74726072ceros
cess65326052ce_ss
cetes75731102cetes
chais107530312chais
chis95933312c_his
cis57748032c__is
clevis1158962clevis
codas84724242codas
codes86247292codes
cods76848102cod_s
coedit9316242coedit
coedits10310242coedits
coeds85920162coed_s
credit9315192credit
credits1039972credits
credos94612852credos
creds85418772cred_s
cris66233432c_ris
cuds76730472cud_s
cutis77723762cutis
cyesis1148572cyesis
defis96717502defis
delis64928542delis
dis46459892__dis
ecesis84611202ecesis
edhs86212102_edhs
edit54934862_edit
edits65819032_edits
eds46638922_ed_s
egis56520652_egis
feds85234312fed_s
gadis74825292gadis
geds66730812ged_s
kadis105921062kadis
kepis115313362kepis
leis45739602le_is
lenis56326862lenis
levis85818552levis
lewis85315842lewis
lexis125916032lexis
media84721712media
medias93620782medias
medic104619652medic
medics114115352medics
medii84513492medii
medius93613282medius
meds75735362med_s
metis75025902metis
midis85923412midis
padis86227142padis
pedes85327292pedes
peds75835242ped_s
penis75129322penis
peris75537072peris
qadis155917852qadis
redds74617832redds
redes65139132redes
redia65524482redia
redias74523602redias
redid74922392redid
redip87816962redip
redips93713842redips
redos65126762redos
reds56042862red_s
reis45343232re_is
sadis64930852sadis
seis45542392se_is
semis74623532semis
teds54932572ted_s
wadis95223962wadis
weds86628932wed_s
yetis85418392yetis
zeds145821802zed_s

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 Filter178691538000.640279204.7
2DLD Change Limit538001152.37622643.1
3Display Results1151150.0303833.3
 (SQL Overall)1786911153.04658664.1
 
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.