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

256 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
zariba173697(None) 
zareba1736421zareba
zaribas1836041zaribas
aria46245422_ari_a
arriba867672arriba
caribe103416742caribe
carina84325322carina
czarina1845952czarina
farina94618232farina
jarina134014062jarina
maria75032882mari_a
marimba1354982marimba
marina84623412marina
tzarina1635052tzarina
varia85824202vari_a
zamia165115212zami_a
zarebas1836302zarebas
zareeba1842422zareeba
zoaria1548372zoari_a
aba512850953_a__ba
abba810522643_a_bba
agita6315423_agita
agria65517143agri_a
airbag956963_airbag
ajiva1586803_ajiva
alba68328333_a_lba
alibi7514223_alibi
aliya83713483_aliya
ameba9312373_ameba
amia66836893_ami_a
amiga85514793_amiga
amrita8411123amrita
anima74620073_anima
araroba945763araroba
arb510448423_ar_b_
arbs66834733_ar_bs
area45843393_ar_ea
areca75618633_areca
arena55323813_arena
arepa75615563_arepa
arias55438023_arias
arid57642713_ari_d
ariel55228973_ariel
aril45843023_ari_l
arils58732203_arils
arise56436433_arise
arista6415293_arista
arnica8310443_arnica
aroma71220143_aroma
arroba898663arroba
atria56022333atri_a
baba88828343ba__ba
baiza164813223ba_iza
barb85240063bar_b_
barbal104016663bar_bal
barbe95328283bar_be
barbie105018353barbie
barbs95928193bar_bs
barca91319433bar_ca
baric96125693bari_c
barilla9310323barilla
baring95135853baring
barista9310813barista
barite84224813barite
barium10313513barium
baryta114310293baryta
bribe94820773_bribe
cambia124913143cambia
camisa103114323camisa
capita102913773capita
carabao1139673carabao
caramba1336893caramba
carb85143163car_b_
carbo94923843car_bo
carbs96031463car_bs
cardia9916373cardia
caribes113715643caribes
caribou1156993caribou
caried94528693caried
caries85147623caries
carinae94318583carinae
carinal94318223carinal
carinas93622383carinas
caring95137993caring
carioca1139683carioca
caritas93316943caritas
carob95325223carob_
carobs104818103carobs
casaba1079263casaba
casita82913703casita
ceiba938693_ceiba
ceria75125353ceri_a
coria75828303cori_a
crib86323573_crib_
cribs94516743_cribs
curia74523763curi_a
czarinas1935293czarinas
czarism2056423czarism
czarist18710223czarist
czaritza1891953czaritza
dagoba1074943dagoba
darb76033533dar_b_
darbar959953dar_bar
darbs85323263dar_bs
daric85623113dari_c
darics94314113darics
daring84928683daring
drib76823253_drib_
dribs85115053_dribs
earing75235483earing
erica7316543_erica
facia103218463faci_a
fajita1635923fajita
farinas103215233farinas
faring105231283faring
farinha13357063farinha
feria85922713feri_a
gamba106018513ga_mba
gambia115912233gambia
garb75332673gar_b_
garbs86321413gar_bs
garda7316763gar_da
garish104516923garish
haika125313793ha_ika
haniwa1236743haniwa
hariana10310243hariana
harijan1735783harijan
haring104233003haring
harissa1035503harissa
jarinas143712183jarinas
kalimba1542663kalimba
karma113415003kar_ma
labia75219003labi_a
lamia75324323lami_a
lamina84920443lamina
lari45839153lari__
lariat6629043lariat
larine63927043larine
laris54737463lari_s
larva8312483lar_va
latina65621143latina
latria62313583latri_a
lorica8310443lorica
mafia104418033mafi_a
mamba116317513ma_mba
mania75634143mani_a
manila84518303manila
mara67444563mar__a
maraca10314153maraca
marimbas1444363marimbas
marinas93519373marinas
marine84230403marine
marish114319053marish
marital92314183marital
marka114620793mar_ka
markka11416593markka
maxima17568633maxima
myrica1336823myrica
naira5314743na_ira
narial6317953narial
naric76824173nari_c
narine63422553narine
naris55735293nari_s
noria55722183nori_a
oaring74225303oaring
ocarina948023ocarina
oribi7311083_oribi
paisa76021073pa_isa
paprica1337003paprica
paprika1544003paprika
para65242173par__a
pareira937533pareira
pariah114320583pariah
parian83223963parian
paries84742513paries
paring94236493paring
paris75145943pari_s
parish115022353parish
parity114719873parity
parka115120883par_ka
partita9310863partita
parura8310583parura
patina86022193patina
prima95019343_prima
raia46638383ra_i_a
raita54623073ra_ita
rarify123210063rarify
raring74332873raring
rarity93615493rarity
ria36745503__ri_a
rib56848023__rib_
ribs65833013__ribs
sahib10314753sahib_
sahibs1137073sahibs
saiga64717933sa_iga
salina64221123salina
saliva93110743saliva
samba95618773sa_mba
sarcina9310733sarcina
sari45444043sari__
sarin55239253sari_n
sarins63932623sarins
saris54544953sari_s
scribal1137963scribal
scribe104613523scribe
sharia93116723shari_a
stria55723203stri_a
tafia84215493tafi_a
taiga64115653ta_iga
tarama8412723tarama
tariff12711353tariff
taring73932283taring
tarsia65514273tarsia
terbia8311153terbia
tribal8611133_tribal
tribe74420263_tribe
tsarina736653tsarina
tzarinas1733973tzarinas
tzarism1866323tzarism
tzarist1659103tzarist
tzaritza1681673tzaritza
urbia7311133_urbia
vagina102710933vagina
vara75530883var__a
varias95019903varias
varied104817863varied
varier94619353varier
varies94330873varies
variola1068893variola
varix154313503vari_x
varna84516173var_na
warier93722893warier
warily122915093warily
waring105029443waring
yerba101010763yer_ba
zaikai1943713za_ikai
zaire14311993za_ire
zaires1539703zaires
zamias174212923zamias
zanana153810363zanana
zanier154314713zanier
zanies153219673zanies
zanily18310183zanily
zanza1378703za_nza
zareebas1943103zareebas
zarf166929123zar__f
zarfs174713623zar_fs
zayin174512043zayi_n
zayins18409713zayins
zoarial1646923zoarial
zoarium1846093zoarium
zori137722923zori__
zoril143916693zori_l
zorilla1646023zorilla
zorils153810883zorils
zoris145320013zori_s

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127162565.86019234.8
3Display Results2562560.0763368.4
 (SQL Overall)1786912566.07629409.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.