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

161 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
zarebas183630(None) 
zareba1736421zareba_
zareebas1943101zareebas
zaribas1836041zaribas
amebas10311452_amebas
areas55935782_are_as
arecas84817442_arecas
arenas65022002_arenas
arepas85515702_arepas
zareeba1842422zareeba_
zariba1736982zariba_
abas68642083_a__bas
abbas95918643_a_bbas
akelas10311193_akelas
albas75925393_a_lbas
ameba9312383_ameba_
amebae1049633_amebae
ameban1039103_ameban
amoebas1135973amoebas
anabas8314083_anabas
ararobas1046183ararobas
arbs66834733_ar_b_s
ardebs937013_ardeb_s
area45843403_are_a_
areae55229753_are_ae
areal55928743_are_al
areca75618633_areca_
arena55323813_arena_
arenes64928393_arenes
areolas71013863_areolas
arepa75615563_arepa_
ares45871023_are__s
aretes64425353_aretes
arias55438033_ar_ias
aromas81018623_aromas
arras55626143_ar_ras
arrobas969213arrobas
azaleas1637003azale_as
babas96325733ba__bas
barbal104016673bar_bal
barbels114514433barbels
barbers114317503barbers
barbes104526233bar_bes
barbets114915843barbets
barbs95928193bar_b_s
barcas101016613bar_cas
bareback1846093bareback
bareboat1249943bareboat
bareboats1345843bareboats
bareges105212033bareges
bares75457133bare__s
barytas12378283barytas
boreas85421733bore_as
calesas9411833calesas
cameras11313363cameras
carabao1139673carabao
carabaos1238083carabaos
carbos105122263car_bos
carbs96031463car_b_s
cardias10715123cardias
careens94514703careens
careers95218783careers
carers85133963care_rs
cares77369183care__s
caress85720263care_ss
carets85330773care_ts
caribes113715643caribes
carinas93622423carinas
caritas93316963caritas
carobs104818103carob_s
casabas1139983casabas
catenas9313113catenas
czardas1934673czar_das
czarevnas2341353czarevnas
czarinas1935303czarinas
dagobas1145143dagobas
darbar959963dar_bar
darbars10510093dar_bars
darbs85323263dar_b_s
darers75921873dare_rs
dares66146703dare__s
daresay1135433daresay
faenas94412763fa_enas
fanegas1145713fanegas
farebox1943823farebox
farers95924053fare_rs
fares85852873fare__s
farinas103215253farinas
favelas1337023favelas
firebase1346493firebase
forebay1538133forebay
forebays1637263forebays
galeas74618513gale_as
galenas83310353galenas
gambas115817513ga_mbas
garbs86321413gar_b_s
gazebos1933493gazebos
grebes93813613_grebes
hareems12428203hareems
harems115513823hare_ms
hares86255543hare__s
jarinas143712203jarinas
karmas123013763kar_mas
larees65323113lare_es
lares54852633lare__s
larvas9310243lar_vas
mambas125716243ma_mbas
maracas11313773maracas
maras75443303mar__as
mares76457633mare__s
marimbas1444363marimbas
marinas93519403marinas
markas124717013mar_kas
markkas12356083markkas
nares55544153nare__s
ourebis936123ourebis
pakehas1635313pakehas
paras76143053par__as
pareiras1038193pareiras
parents93418133parents
pareos87023773pare_os
parers85530743pare_rs
pares77164483pare__s
pareses94718883pareses
paresis93315093paresis
pareus85420743pare_us
parkas125018033par_kas
paruras9310543paruras
rarebit948423rarebit
rarebits1045223rarebits
rares55247443rare__s
rebar75420193__rebar
rebars84019833__rebars
rebs65733563__reb_s
rebus75721113__rebus
sambas104219263sa_mbas
sarees65329943sare_es
taramas9612713taramas
tares57456563tare__s
tarsias74013373tarsias
tzarevnas215953tzarevnas
tzarinas1733973tzarinas
ureas55826013_ure_as
varas86028203var__as
varias95019913var_ias
varnas94212833var_nas
wares88250583ware__s
yerbas11119293yer_bas
zaires1539703zaire__s
zamias174212923za_mias
zananas16319563zananas
zanzas1487053za_nzas
zarfs174713623zar__fs
zarzuelas175963zarzuelas
zaxes215113823zaxe__s
zazens1435833zaze_ns
zebras1737853z__ebras
zebus164610053z__ebus
zetas145018163z__etas
zinebs17606803zineb_s
zoeas145815613z_oe_as

Search took 9 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.440406115.9
2DLD Change Limit1340271617.50017870.3
3Display Results1611610.0602683.3
 (SQL Overall)1786911618.00022336.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.