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

230 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
zareba173642(None) 
zarebas1836301zarebas
zareeba1842421zareeba
zariba1736971zariba
ameba9312372_ameba
area45843392_are_a
areca75618632_areca
arena55323812_arena
arepa75615562_arepa
zareebas1943102zareebas
zaribas1836042zaribas
aba512850953_a__ba
abba810522643_a_bba
aceta74017353_aceta
akela9311343_akela
alba68328333_a_lba
amebae1049633_amebae
ameban1039093_ameban
amebas10311453_amebas
amoeba1035593amoeba
araroba945763araroba
arb510448423_ar_b_
arbs66834733_ar_bs
ardeb8314523_ardeb_
ardebs937013_ardebs
are37874573_are__
areae55229743_areae
areal55928733_areal
areas55935773_areas
arecas84817443_arecas
areic73219393_areic
arenas65021993_arenas
arene55329413_arene
areola6813673_areola
arepas85515703_arepas
ares45871023_are_s
arete56031353_arete
aria46245423_ar_ia
aroma71220143_aroma
arriba867673arriba
arroba898663arroba
asea46327183_ase_a
azalea1537003azale_a
baba88828343ba__ba
barb85240063bar_b_
barbal104016663bar_bal
barbe95328283bar_be
barbed115121313barbed
barbel104317073barbel
barber104419323barber
barbes104526233barbes
barbet104427883barbet
barbs95928193bar_bs
barca91319433bar_ca
bare65460523bare__
bareback1846093bareback
bareboat1249943bareboat
bared85144483bare_d
barege94713543barege
barely114716793barely
barer74535803bare_r
bares75457133bare_s
barest85327693barest
baryta114310293baryta
caeca93915133ca_eca
calesa8412473calesa
camera10313673camera
carabao1139673carabao
caramba1336893caramba
carb85143163car_b_
carbo94923843car_bo
carbs96031463car_bs
cardia9916373cardia
care66968373care__
cared86050093care_d
careen84119493careen
career85822243career
carer74942333care_r
carers85133953carers
cares77369183care_s
caress85720263caress
caret75360563care_t
carets85330773carets
carex144822293care_x
caribe103416743caribe
carina84325323carina
carob95325223carob_
carobs104818103carobs
casaba1079263casaba
catena8312473catena
cerebra1155913cerebra
czarevna2241253czarevna
czarina1845953czarina
dagoba1074943dagoba
darb76033533dar_b_
darbar959953dar_bar
darbs85323263dar_bs
dare55848863dare__
dared75935013dare_d
darer65230793dare_r
darers75921873darers
dares66146703dare_s
daresay1135433daresay
eared65139503eare_d
eureka1034483eureka
faena85014203fa_ena
fanega1055783fanega
fare76354463fare__
farebox1943823farebox
fared95842343fare_d
farer86733143fare_r
farers95924053farers
fares85852873fare_s
farina94618233farina
favela1237033favela
forebay1538133forebay
foreby1438633foreby
fraena938063fraena
frena85915273_frena
galea64722933gale_a
galena74911093galena
gamba106018513ga_mba
garb75332673gar_b_
garbed104815663garbed
garbs86321413gar_bs
garda7316763gar_da
gazebo1833673gazebo
gleba83910243_gleba
grebe85114943_grebe
hare76255733hare__
hared95742183hare_d
hareem114312063hareem
harem104924453hare_m
harems115513823harems
hares86255543hare_s
hereby14468333hereby
jarina134014063jarina
karma113415003kar_ma
laree56036293lare_e
larees65323113larees
lares54852633lare_s
larva8312483lar_va
mamba116317513ma_mba
mara67444563mar__a
maraca10314153maraca
mare64759323mare__
maremma1044463maremma
mares76457633mare_s
maria75032883mar_ia
marimba1354983marimba
marina84623413marina
marka114620793mar_ka
markka11416593markka
nares55544153nare_s
oared65030653oare_d
ocrea73311823ocre_a
ourebi837173ourebi
pakeha1533933pakeha
palea75028663pale_a
para65242173par__a
pare66760843pare__
pared86946763pare_d
pareira937533pareira
parent83230423parent
pareo74632603pare_o
pareos87023773pareos
parer75839903pare_r
parerga1035173parerga
parers85530743parers
pares77164483pare_s
pareu74928743pare_u
pareus85420743pareus
pareve114613013pareve
parka115120883par_ka
parura8310583parura
perea75026443pere_a
pereia85217983pereia
presa74319043_presa
rare45348433rare__
rarebit948423rarebit
rared65738323rare_d
rarefy12296343rarefy
rarely93513653rarely
rarer54731703rare_r
rares55247443rare_s
rarest65725483rarest
reb55844963__reb_
rebar75420193__rebar
rebs65733563__rebs
samba95618773sa_mba
saree55044663sare_e
sarees65329943sarees
tapeta8310693tapeta
tarama8412723tarama
tare45957623tare__
tared69340053tare_d
tares57456563tare_s
tarsia65514273tarsia
tzarevna204973tzarevna
tzarina1635053tzarina
urea46528053_ure_a
vara75530883var__a
varia85824203var_ia
varna84516173var_na
ware76254723ware__
wared96339873ware_d
wares88250583ware_s
yare75636943yare__
yarely122810303yarely
yarer84321573yare_r
yarest95018913yarest
yerba101010763yer_ba
zaire14311993zaire__
zaires1539703zaire_s
zamia165115213za_mia
zanana153810363zanana
zanza1378703za_nza
zarf166929123zar__f
zarfs174713623zar_fs
zarzuela164753zarzuela
zaxes215113823zaxe_s
zazen1337283zaze_n
zazens1435833zazens
zebra1637883z__ebra
zebu153414723z__ebu
zeta135121643z__eta
zineb165614143zineb_
zinebs17606803zinebs
zoaria1548373zoar_ia
zoea137118423z_oe_a

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 Limit1127162306.20318171.2
3Display Results2302300.0802875.0
 (SQL Overall)1786912306.42327820.5
 
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.