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
areas55935772_are_as
arecas84817442_arecas
arenas65021992_arenas
arepas85515702_arepas
zareeba1842422zareeba_
zariba1736972zariba_
abas68642083_a__bas
abbas95918643_a_bbas
akelas10311193_akelas
albas75925393_a_lbas
ameba9312373_ameba_
amebae1049633_amebae
ameban1039093_ameban
amoebas1135963amoebas
anabas8314083_anabas
ararobas1046183ararobas
arbs66834733_ar_b_s
ardebs937013_ardeb_s
area45843393_are_a_
areae55229743_are_ae
areal55928733_are_al
areca75618633_areca_
arena55323813_arena_
arenes64928393_arenes
areolas71013863_areolas
arepa75615563_arepa_
ares45871023_are__s
aretes64425353_aretes
arias55438023_ar_ias
aromas81018613_aromas
arras55626133_ar_ras
arrobas969213arrobas
azaleas1636993azale_as
babas96325733ba__bas
barbal104016663bar_bal
barbels114514433barbels
barbers114317503barbers
barbes104526233bar_bes
barbets114915843barbets
barbs95928193bar_b_s
barcas101016603bar_cas
bareback1846093bareback
bareboat1249943bareboat
bareboats1345823bareboats
bareges105212033bareges
bares75457133bare__s
barytas12378283barytas
boreas85421733bore_as
calesas9411823calesas
cameras11313343cameras
carabao1139673carabao
carabaos1238073carabaos
carbos105122263car_bos
carbs96031463car_b_s
cardias10715093cardias
careens94514703careens
careers95218783careers
carers85133953care_rs
cares77369183care__s
caress85720263care_ss
carets85330773care_ts
caribes113715643caribes
carinas93622383carinas
caritas93316943caritas
carobs104818103carob_s
casabas1139983casabas
catenas9313103catenas
czardas1934673czar_das
czarevnas2341353czarevnas
czarinas1935293czarinas
dagobas1145143dagobas
darbar959953dar_bar
darbars10510093dar_bars
darbs85323263dar_b_s
darers75921873dare_rs
dares66146703dare__s
daresay1135433daresay
faenas94412763fa_enas
fanegas1145713fanegas
farebox1943823farebox
farers95924053fare_rs
fares85852873fare__s
farinas103215233farinas
favelas1337023favelas
firebase1346493firebase
forebay1538133forebay
forebays1637263forebays
galeas74618503gale_as
galenas83310333galenas
gambas115817513ga_mbas
garbs86321413gar_b_s
gazebos1933493gazebos
grebes93813613_grebes
hareems12428203hareems
harems115513823hare_ms
hares86255543hare__s
jarinas143712183jarinas
karmas123013733kar_mas
larees65323113lare_es
lares54852633lare__s
larvas9310233lar_vas
mambas125716243ma_mbas
maracas11313773maracas
maras75443283mar__as
mares76457633mare__s
marimbas1444363marimbas
marinas93519373marinas
markas124717003mar_kas
markkas12356083markkas
nares55544153nare__s
ourebis936123ourebis
pakehas1635313pakehas
paras76143043par__as
pareiras1038183pareiras
parents93418123parents
pareos87023773pare_os
parers85530743pare_rs
pares77164483pare__s
pareses94718873pareses
paresis93315093paresis
pareus85420743pare_us
parkas125018023par_kas
paruras9310533paruras
rarebit948423rarebit
rarebits1045223rarebits
rares55247443rare__s
rebar75420193__rebar
rebars84019823__rebars
rebs65733563__reb_s
rebus75721113__rebus
sambas104219263sa_mbas
sarees65329943sare_es
taramas9612693taramas
tares57456563tare__s
tarsias74013373tarsias
tzarevnas215953tzarevnas
tzarinas1733973tzarinas
ureas55826013_ure_as
varas86028193var__as
varias95019903var_ias
varnas94212823var_nas
wares88250583ware__s
yerbas11119293yer_bas
zaires1539703zaire__s
zamias174212923za_mias
zananas16319563zananas
zanzas1487053za_nzas
zarfs174713623zar__fs
zarzuelas175953zarzuelas
zaxes215113823zaxe__s
zazens1435833zaze_ns
zebras1737853z__ebras
zebus164610053z__ebus
zetas145018163z__etas
zinebs17606803zineb_s
zoeas145815613z_oe_as

Search took 8 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.1561145455.1
2DLD Change Limit1340271617.00019146.7
3Display Results1611610.0503220.0
 (SQL Overall)1786911617.20624797.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.