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

147 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
ricrac103701(None) 
ricracs1136361ricracs
micra96214972micra_
picric12309922picric
rickrack1544092rickrack
rictal83113182rictal
riprap1055512riprap
tictac1036562tictac
trictrac1244412trictrac
amtrac10109133amtrac
bicarb1238543bicarb
bicron103710773bicron
circa9311403circa_
citral81113893citral
citric102812313citric
crab85727673__crab
crack134120533__crack
crag75625303__crag
cram85635493__cram
crap85731843__crap
craw97725263__craw
croc85723733__croc
dicta84915633dicta_
diram84419473di_ram
erica7316543eric_a_
ericas8315463eric_as
gimcrack1942443gimcrack
hijra1535643hijra_
hijrah1934283hijrah
hijras1635773hijras
ictic9311803_ictic
ihram10310183_ihram
ileac75814173_ileac
iliac75013493_iliac
libra74712423libra_
librae84310173librae
libras83711703libras
lilac7311073li_lac
linac7315413li_nac
lira46928683li_ra_
liras56021983li_ras
lycra10317973lycra_
lycras11287253lycras
mica86428253mic_a_
micas96823053mic_as
micro94715993micr_o
micron103714283micron
micros104115363micros
mihrab1335523mihrab
mikra114610313mikra_
mitral81314323mitral
nicad8312613nic_ad
nitric82512063nitric
pica85831493pic_a_
pical95524373pic_al
picara10311903picara
picaras11311283picaras
picaro10311323picaro
picas94626523pic_as
pickax2135913pickax
picnic123410263picnic
picrate112014143picrate
piracy1339473pi_racy
racial83419243racial
recap95718023rec_ap
reclad9311873reclad
recoal84117973recoal
recoat84024273recoat
recrate92621663recrate
recta74220263recta_
rectal84418133rectal
redraw10269853redraw
refract121311603refract
rerack122513163r_erack
reran57329103r_eran
retrace91417343retrace
retrack131310723retrack
retract91318113retract
retral64419743retral
rewrap11127533rewrap
ria36745503ri__a_
rial45938093ri__al
rias45540593ri__as
riata54618023riata_
riatas63915093riatas
rice64942913ric__e
riced85825543ric_ed
ricer74726613ric_er
ricercar1263333ricercar
ricers84120993ricers
rices75536153ric_es
rich97025543ric__h
richen113812513richen
richer114015043richer
riches115022083riches
richly1438003richly
ricin74620213ric_in
ricing94822763ricing
ricins83618703ricins
rick107334653ric__k
ricked136523623ricked
rickey154613973rickey
rickracks1643813rickracks
ricks115126133ric_ks
rictus8379193rictus
rimrock1544383rimrock
rioja1236303rioja_
riojas1335813riojas
ripraps1134943ripraps
ripsaw1134283ripsaw
ristra6310713ristra_
ristras7311563ristras
ritard74812083ritard
ritual6310623ritual
rival85216503ri_val
riyal84413433ri_yal
rubric1097823rubric
rural55821173r_ural
sacra74516993sacra_
sacral83414413sacral
scrag85916173_scrag
scram910621623_scram
scrap97120403_scrap
serac75925203_serac
siccan1037593siccan
sirra54416323sirra_
sirrah9379753sirrah
sirras63814863sirras
tiara5315913tiara_
tiaras6314553tiaras
tical76021493tic_al
tictacs1145793tictacs
tictoc1036003tictoc
triac74116373tri__ac
tribrach1543733tribrach
triclad1037443triclad
trictracs1344043trictracs
trigram1077763trigram
vicar10513863vic_ar
vicars11712263vicars
viral86419593vi_ral
vitric112510113vitric
wicca1247253wicca_
wiccan1335033wiccan
wiccas1336543wiccas
wirra83210823wirra_
ziram163912893zi_ram

Search took 6 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 Filter1786911127160.373479064.3
2DLD Change Limit1127161475.04622337.7
3Display Results1471470.0463195.7
 (SQL Overall)1786911475.46532697.3
 
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.