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

234 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
ratbag95656(None) 
ragbag1045461ragbag
ratbags1035761ratbags
gasbag1035412gasbag
kitbag1334972kitbag
rabat72832222ra_bat
ragbags1135112ragbags
ragtag836642ragtag
ratal55025112rat_al
ratan53722662rat_an
rating74938702rating
rattan63613602rattan
retag63618412ret_ag
aba512850953_a_ba_
abas68642083_a_bas
abba810522653_abba_
abbas95918643_abbas
airbag956963airbag
alba68328333_alba_
albas75925393_albas
ambage11510603_ambage
artal55525473art_al
atabal839743_atabal
atap66722453_at_ap
atlas55821583_atlas
atma68121773_atma_
atman75520143_atman
atmas75721013_atmas
attar56516693_attar
baba88828353ba_ba_
babas96325733ba_bas
bag67059223___bag
baobab946403baobab
barbal104016663barbal
batboy1387533batboy
bateau8810563bateau
bating95132253bating
batman105214063batman
beanbag1243943beanbag
cabal95222153ca_bal
cabbage1446983cabbage
cabbagy1744013cabbagy
casbah1337903casbah
catboat11412243catboat
catjang1733923catjang
catnap1098383catnap
crating103725203crating
darbar959953darbar
data56026653dat_a_
dating85326483dating
debag94212303_debag
dirtbag1143023dirtbag
drawbar13103193drawbar
eating75134403eating
fatal84819373fat_al
fatback1836923fatback
fating105328673fating
fatwa1168063fatwa_
fatwas1249053fatwas
footbag1344553footbag
gamba106018513gamba_
gambas115817513gambas
garbage1138053garbage
garbagy1444243garbagy
gasbags1135473gasbags
gateau778113gateau
gating84826953gating
grating93923183grating
graylag1283113graylag
handbag1495863handbag
hatband1346823hatband
hatbox1835133hatbox
hating104929713hating
jetlag1434523jetlag
kabab134814443ka_bab
kabar114815553ka_bar
kanban1238623kanban
kasbah1535183kasbah
kata85626023kat_a_
katas95922093kat_as
kitbags1443883kitbags
mailbag1243923mailbag
mamba116317523mamba_
mambas125716243mambas
mating94832913mating
matsah1138233matsah
matza16311813matza_
matzah2035963matzah
matzas1749703matzas
natal53921493nat_al
orating83520323orating
outbeg938733outbeg
outbrag1036993outbrag
padnag1036073padnag
postbag1245223postbag
prating103424453prating
rabato83413263ra_bato
rabats83116223ra_bats
rabbet103818653rabbet
rabbi93113183ra_bbi
rabbin103112303rabbin
rabbis102613163rabbis
rabbit102914563rabbit
rabble103818243rabble
rabic93817403ra_bic
rabid84520783ra_bid
racial83419243racial
racing95030533racing
radar61316723ra_dar
radial74020393radial
radian74117273radian
rafting113815753rafting
rag45761323r___ag
raga55930813ra_ga_
ragas65326063ra_gas
ragg65622693ra__gg
raging85126433raging
raglan73711503raglan
ragman94013713ragman
ragtags935373ragtags
raia46638383ra_ia_
raias54631123ra_ias
raita54623073raita_
raitas64417673raitas
raja117918683ra_ja_
rajah155711423ra_jah
rajas127317723ra_jas
raking114728423raking
ramal74622243ra_mal
rambla103510933rambla
ramblas112710263ramblas
ramble104519973ramble
rampage1237453rampage
randan7315253randan
rang56939163ra__ng
ranting84025413ranting
raphae114311733raphae
raping94829853raping
raring74332873raring
rascal8511123rascal
rasing74330833rasing
rat37892743rat___
ratable91717553ratable
ratably121711513ratably
ratals64219583ratals
ratans63819373ratans
ratany93411873ratany
ratatat7412263ratatat
ratch104221363rat_ch
rate45458763rat__e
rated65441383rat_ed
ratel54224883rat_el
ratels64518213ratels
rater54943283rat_er
raters63936583raters
rates55352013rat_es
rath76037663rat__h
rathe85821923rat_he
rather94319743rather
ratify122610043ratify
ratine65131823ratine
ratings84217413ratings
ratio55227583rat_io
ration64226013ration
ratios64922673ratios
ratite65022423ratite
ratlin64116523ratlin
rato45436973rat__o
ratoon64417373ratoon
ratos55528763rat_os
rats46260373rat__s
ratsbane10184343ratsbane
rattail737803rattail
rattans73411953rattans
ratted74923343ratted
ratten64217383ratten
ratter64326313ratter
ratting83822363ratting
rattle64717613rattle
rattly94111543rattly
ratton64116123ratton
rattrap945263rattrap
ratty84819593rat_ty
ravage1039303ra_vage
raving105128853raving
raxing144321023raxing
raya75224823ra_ya_
rayah116013503ra_yah
rayas85922053ra_yas
raying105027193raying
razing164524543razing
reata54225393reat_a_
reatas64021013reat_as
rebar75420193r_ebar
redbay1238333redbay
redbug10165473redbug
reflag1098083reflag
retags73414303ret_ags
retax124517973ret_ax
reteam83214533reteam
retear63115483retear
retia55326113retia_
retial64724993retial
retral64419743retral
riata54618023riat_a_
riatas63915093riat_as
ritual6310623ritual
rota45834343rot_a_
rotas54827723rot_as
rumba93612513rumba_
rumbas102512013rumbas
rurban849043rurban
rutabaga1141283rutabaga
sabal75422483sa_bal
sabbat10314713sabbat
samba95618773samba_
sambal105215183sambal
sambar103914163sambar
sambas104219263sambas
sandbag11106243sandbag
satang75711563satang
satay84718463sat_ay
sating74735453sating
satrap86212553satrap
seabag938473seabag
stag57332003_st_ag
stalag7310023stalag
tag47259493__t_ag
tagrag837043tagrag
tambac122210243tambac
tambak14249263tambak
tatar56122063tat_ar
watap102111673wat_ap
wattage1186983wattage

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.390458182.1
2DLD Change Limit1127162345.12322002.0
3Display Results2342340.0633714.3
 (SQL Overall)1786912345.57632046.4
 
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.