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
cedi74919281cedi_
acedia9310402acedia
acedias1039772acedias
aedes64625152aedes
aegis6316782aegis
bedim10313832bedim
bedims1149592bedims
beds75937792bed_s
bidis86721152bidis
caddis104613382caddis
cades85440732cades
cadi75732192cadi_
cads76144532cad_s
caids85226432caids
cebid104314082cebid
cebids11439182cebids
cedar84014322cedar
cedars93312832cedars
cede74928782ced_e
ceded96118562ceded
ceder85322242ceder
ceders93817672ceders
ceding104014802ceding
cees65941592ce_es
ceil65725062ce_il
ceilis85413742ceilis
ceils75019402ceils
cells75428062cells
cels65534972ce_ls
celts75325782celts
cents74730332cents
cepes94424462cepes
ceps86125952ce_ps
cercis104614492cercis
ceres75540012ceres
ceria75125362ceria
cerias83321982cerias
ceric94023092ceric
cerise84822042cerise
ceros74726072ceros
cess65326052ce_ss
cetes75731102cetes
chais107530312chais
chis95933312c_his
cis57748042c__is
clevis1158962clevis
codas84724242codas
codes86247292codes
cods76848112cod_s
coedit9316242coedit
coedits10310242coedits
coeds85920162coed_s
credit9315192credit
credits1039972credits
credos94612852credos
creds85418772cred_s
cris66233432c_ris
cuds76730482cud_s
cutis77723762cutis
cyesis1148572cyesis
defis96717502defis
delis64928542delis
dis46459902__dis
ecesis84611202ecesis
edhs86212102_edhs
edit54934872_edit
edits65819032_edits
eds46638932_ed_s
egis56520652_egis
feds85234322fed_s
gadis74825292gadis
geds66730822ged_s
kadis105921072kadis
kepis115313362kepis
leis45739602le_is
lenis56326862lenis
levis85818552levis
lewis85315842lewis
lexis125916032lexis
media84721712media
medias93620782medias
medic104619652medic
medics114115352medics
medii84513492medii
medius93613282medius
meds75735372med_s
metis75025902metis
midis85923422midis
padis86227142padis
pedes85327292pedes
peds75835252ped_s
penis75129322penis
peris75537072peris
qadis155917852qadis
redds74617832redds
redes65139132redes
redia65524482redia
redias74523602redias
redid74922392redid
redip87816962redip
redips93713842redips
redos65126762redos
reds56042872red_s
reis45343232re_is
sadis64930852sadis
seis45542392se_is
semis74623532semis
teds54932582ted_s
wadis95223962wadis
weds86628942wed_s
yetis85418392yetis
zeds145821812zed_s

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 Filter178691538000.310576422.6
2DLD Change Limit538001151.75030742.9
3Display Results1151150.0502300.0
 (SQL Overall)1786911152.11084687.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.