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

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

223 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
credited123825(None) 
coedited1237831coedited
accredited1642662accredited
chedite1338862chedite_
chedites1438262chedites
created104323452cre_ated
credit9315192credit__
creditor1145902creditor
credits1039972credit_s
cremated133412962cremated
crenated113013912crenated
crested103416532cre_sted
creviced1634452creviced
crudites1137762crudites
edited83913672__edited
inedited10278992inedited
precited133013812precited
predated12513272predated
predicted1538912predicted
preedited1337632preedited
recited104319102_recited
redated93120922_redated
reedited10310082reedited
resited85122422_resited
uncredited1445002uncredited
unedited10249832unedited
arenite71017713arenite_
arenites8917103arenites
audited939033_audited
breasted1138823breasted
breveted1435623breveted
bruited104110353br_uited
caddied123710563caddi_ed
caddised13315893caddised
candied113816023candi_ed
caudated1238063caudated
ceded96118563c_ed__ed
ceiled94114953c_e_iled
cerated103922473c_erated
cerite84724873c_erite_
cerites94823433c_erites
cheated134416343che_ated
cheddite1543953cheddite_
cheddites1643013cheddites
chelated142610483chelated
cheliped1635043cheliped
chested133811673che_sted
chevied16357483chevi_ed
circuited1444563circuited
cited84421953c___ited
cleated103417843cle_ated
clefted13326753cle_fted
coedit9316243coedit__
coeditor1145723coeditor
coedits10310243coedit_s
coempted1535333coempted
coesite9713623coesite_
coesites101313093coesites
coexisted1944143coexisted
copyedited1951953copyedited
cordite10315263cordite_
cordites11314623cordites
corelated12411823corelated
cradled113410813crad_led
crafted13419773cr_afted
crated94827773cr__ated
creaked143413233cre_aked
creamed123913713cre_amed
creased104315583cre_ased
create85126383cre_ate_
creates95225203cre_ates
credible1346023credible
credibly1644713credibly
crediting1338843crediting
creditors1245873creditors
creed85727393cre___ed
creeled104012013cre_eled
creeped12329713cre_eped
creeshed1435693creeshed
cremate113816183cremate_
cremates124216003cremates
crenate93317113crenate_
creneled11326893creneled
creolised1255203creolised
creolized2145643creolized
creosoted1244043creosoted
creped114115703cre__ped
crepier1139743crepi_er
crepitated1584743crepitated
crevice1436153crevice_
crevices1536713crevices
crewed125316563cre__wed
cried84624283cr__i_ed
crinite9513633crinite_
crinites10612763crinites
crudded1235733crud_ded
crudities1247743crudities
crudity1336043crudit_y
cruised103710213cr_uised
crusted103712753cr_usted
curetted1137173cure_tted
debited113311623_debited
discredited1653603discredited
dredged11346893dred_ged
endited93512913_endited
eradiated11178813eradiated
erected103213993ere_cted
eremite9312833eremite_
eremites10312603eremites
erudite838483erudite_
evited104013143__evited
exited144712523__exited
expedited2044933expedited
foredated1447683foredated
fretted113411853fre_tted
fruited11389093fr_uited
gradated1157433gradated
grecized2134433grecized
greeted93111383gre_eted
indited93515023_indited
lenited8812433_lenited
mediated123011873_mediated
merited10313853_merited
misedited1346783misedited
orbited1037733or_bited
overedited1547213overedited
preacted132710943preacted
precised133213413precised
predate10616893predate_
predates11615813predates
predicated1649143predicated
predive13511083predive_
predried12309573predried
prefiled143310573prefiled
prefired144310753prefired
prefixed21357703prefixed
premised133013193premised
premixed20338013premixed
presided12410553presided
presifted1536873presifted
prettied1159253prettied
preunited1246803preunited
prevised143611073prevised
prewired14358473prewired
profited14279973profited
radiated102512593_radiated
radioed939673_radioed
reacted103015713_reacted
readied93316623_readi_ed
rebaited11410543_rebaited
rebated103619703_rebated
recite83625113_recite_
reciter94117263_reciter
recites93524583_recites
redacted12410243_redacted
redate74124683_redate_
redates83423873_redates
redbaited1344713_redbaited
redded94019553_red_ded
reddled102912323_reddled
reded74829123_red__ed
rediae74221993_rediae_
redialed10310793_redialed
redid74922393_redi__d
redipped1434783_redipped
redlined103811233_redlined
redried93714893_redried
reduced11610323_reduced
redyed114611243_red_yed
reested82916233_reested
refiled114318653_refiled
refined114720003_refined
refired115116993_refired
refitted12309413_refitted
refixed183611153_refixed
refuted114313803_refuted
rehired115013153_rehired
reined74425523_re_ined
reived104518133_re_ived
related83327573_related
relied74926233_reli_ed
relined85321933_relined
relisted9312623_relisted
relived115114683_relived
remated103522473_remated
reminted113615083_reminted
remised103516843_remised
remitted113312073_remitted
remixed173510743_remixed
rented74426593_re_nted
reoiled84316853_reoiled
repined104918773_repined
reputed104613483_reputed
requited18169723_requited
resided95217703_resided
resifted12310153_resifted
resiled84621983_resiled
resined84522653_resined
resisted9312693_resisted
resite64128453_resite_
resites74027793_resites
resized174614903_resized
respited11410813_respited
rested74430783_re_sted
retied75924983_reti_ed
retiled84420513_retiled
retimed104714653_retimed
retinted94414363_retinted
retired84620143_retired
retitled9339553_retitled
retted74826313_re_tted
reunited939713_reunited
reviled114417923_reviled
revised113815483_revised
revived144211653_revived
revoted114314153_revoted
rewired115413283_rewired
sedated93714353_sedated
subedited1345543subedited
treated83618703tre_ated
treddled1134473treddled
verditer1236223verditer
wrested113410933wre_sted

Search took 8 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 Filter1786911461620.423422437.4
2DLD Change Limit1461622237.03020791.2
3Display Results2232230.1102027.3
 (SQL Overall)1786912237.56323627.0
 
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.