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

236 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
ritards843994(None) 
retards85015001retards
ritard74812081ritard_
briards10398552bri_ards
dotards937252dotards
liards75212612li_ards
lizards17427612lizards
petards104311152petards
regards94112562regards
retard75018932retard_
rewards114813992rewards
ribalds10236672ribalds
ribands10208392ribands
sitars65417592sitar_s
unitards945622unitards
visards11328152visards
vizards20377262vizards
wizards20326402wizards
altars64518153altar_s
attars64515313attar_s
awards107113453_awards
bards87139643__bards
bastards113310313bastards
bayards13379683bayards
beards94116673_beards
bicarbs1336013bicarbs
birds85421333bi__rds
biters83925243biter_s
boards94616933_boards
boyards13399323boyards
briard94311293bri_ard_
briars84814823bri_ar_s
brigands1245623brigands
bustards11308513bustards
canards10311203canards
cards85137933__cards
chards125119733_chards
cigars9910723cigar_s
citers85022983citer_s
citharas13156723citharas
citrals91111673citrals
citrus83610923cit_rus
costards113510793costards
cowards1339613cowards
custards11338393custards
dastards10278083dastards
diehards1346213diehards
dinars75417563dinar_s
disarms1039043disarms
discards1238913discards
ditas65923673dita__s
dotard839053dotard_
echards1337963echards
fards96629843__fards
fiars86720833fi_ar_s
fiords10498623fi_ords
friars93812093fri_ar_s
girds74816993gi__rds
gitanos837173gitanos
gizzards18133263gizzards
guards84611573_guards
guisards1043603guisards
guitars8116863guitar_s
hards96435653__hards
hazards2037463hazards
hoards104912623_hoards
holards1148433holards
inarms8410093_inarms
innards837153innards
inwards1138343inwards
izars145112933_izar_s
izzards16143963izzards
jihads1734483jiha_ds
kinaras1159123kinaras
kiters105218593kiter_s
kitharas15165413kitharas
lards65331863__lards
leotards945303leotards
liard65418593li_ard_
liars54723163li_ar_s
lidars7310783lidar_s
ligands9438983ligands
litas54923773lita__s
liters65429883liter_s
litres65220393lit_res
lizard16369233lizard_
mazards1937703mazards
milords10117853milords
misadds1136303misadds
miters84328783miter_s
mitres83922073mit_res
mustards11297883mustards
nards65928463__nards
nicads938333nica_ds
niggards1144123niggards
niters64624213niter_s
nitres65519333nit_res
nitrids8269633nitrids
nitros64214123nit_ros
octads987333octa_ds
onwards1137173onwards
orchards1445913orchards
ottars64112223ottar_s
outadds936203outadds
outwards1299123outwards
pards85634333__pards
petard95013803petard_
picaras11311283picaras
picaros11310893picaros
pitas77427673pita__s
pitayas1286263pitayas
qintars16268573qintar_s
radars71314673radar_s
rads56046603r__a_ds
raids65827513r__aids
raitas64417673raita__s
rands65930453r__ands
rares55247443r__ares
ratals64219583rata_ls
ratans63819373rata_ns
raters63936583rater_s
readds84111643r_eadds
reads64835273r_ea_ds
rearms85114653r_earms
rears54739653r_ear_s
rebars84019833rebar_s
reboards1138773reboards
records105213923records
reearns749103reearns
regard85215773regard_
relands85214883relands
remands104914883remands
remarks13329983remarks
reparks13249513reparks
restarts8310873restarts
retacks132210713retacks
retags73414303reta_gs
retails74718973retails
retains74522253retains
retakes113718863retakes
retapes93917423retapes
retarded102410753retarded
retarder9229433retarder
retarders10227573retarders
retaxes143615093retaxes
retears72814923retear_s
retires74726213retires
retorts76016513retorts
retros63820193ret_ros
returns79712593returns
reward106017643reward_
rewarms12439603rewarms
rewords115413983rewords
reynards1244303reynards
rials55026673ri_a_ls
rias45540593ri_a__s
riatas63915093ri_atas
ribald9209293ribald_
riband9239623riband_
ribbands1344563ribbands
ricers84120993ricer_s
ricracs1136363ricracs
riders74123903rider_s
rids56539543ri___ds
rigors72813713rigor_s
rimers84522553rimer_s
rimlands1145243rimlands
rinds64826143ri__nds
rioters73615513rioter_s
ripcords1344073ripcords
ripraps1134943ripraps
risers64624783riser_s
ristras7311563ristras
rites54442553rit__es
ritters74020623ritters
rituals738353rituals
ritzes154812943rit_zes
rivages1138873rivages
rivals94213183riva_ls
rivers94626543river_s
riyals94111083riya_ls
roads66523623r_oa_ds
roars55622243r_oar_s
robands10219863robands
rotaries8315693rotaries
rotary92411303rotar_y
rotas54827723rota__s
rotates72819773rotates
rotors64917953rotor_s
sards64736183__sards
sataras7315063sataras
shards104319173_shards
simars84916933simar_s
sitar54820543sitar__
sitarist8315283sitarist
sizars154812623sizar_s
stands75118053_stands
stares66038753_stares
stars55836573_star_s
starts65423123_starts
swards105415133_swards
tabards10310383tabards
tads57143943__ta_ds
tardo65321103__tardo
tardy94720463__tardy
tares57456563__tares
tarns56433953__tarns
taros55640823__taros
tarps76527113__tarps
tars46763953__tar_s
tarts57242023__tarts
tatars64619793tatar_s
tetrads82910193tetrads
tiaras6314553ti_aras
tiltyards1362593tiltyards
titans63414913tita_ns
titers64526413titer_s
titlarks1243693titlarks
titres64718933tit_res
towards1138783towards
triads74513533tri_a_ds
turds65021693__turds
unitard838003unitard_
upwards13135963upwards
vawards14457573vawards
viands1047813vi_ands
vicars11712263vicar_s
visard103910123visard_
vitals94514303vita_ls
vizard19458853vizard_
wards97734403__wards
witans93412933wita_ns
wizard19377713wizard_
writers105513493writer_s
yards95324613__yards
yirds96612513yi__rds

Search took 7 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 Filter1786911340270.406440125.6
2DLD Change Limit1340272366.47020715.1
3Display Results2362360.0902622.2
 (SQL Overall)1786912366.96625651.9
 
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.