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

188 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
marblier125634(None) 
marbler113511671marbl_er
marlier92614771mar_lier
burblier1255602burblier
darklier1335012darklier
earlier72612742ear_lier
garbler104012562garbl_er
manlier92414022ma_nlier
marble104219102marbl_e_
marbled123212112marbl_ed
marblers12319232marbl_ers
marbles114516652marbl_es
marbliest1336762marbliest
marbling13179882marbling
marrier93817522mar_rier
marshier1337592marshier
wabblier15375492wabblier
wamblier15275732wamblier
warbler123211462warbl_er
abler75624313_a_bl_er
ambler104916453_ambl_er
applier1137903_applier
arbiter939933_arbiter
artier63419733_ar_tier
artsier768943_artsier
atelier7311623_atelier
babbler104012823babbl_er
babier103515573ba_b_ier
bairnlier1142233bairnlier
barber104419323barb__er
barbie105018353barb_ie_
barbies114519593barb_ies
barbwire1543863barbwire
barflies1338303barflies
barkier133814483bar_kier
barmier114313043bar_mier
barnier93213673bar_nier
barrier94017733bar_rier
bramblier1543503bramblier
brawlier13267043brawlier
bubblier1184473bubblier
burbler114412423burbl_er
burlier93514413bur_lier
cabler104519173ca_bl_er
caroler93816753carol_er
caroller1039203caroller
carrier93619583car_rier
catbrier1236173catbrier
cavalier1348173cavalier
crabbier14326803crabbier
crawlier13216873crawlier
curlier93314183cur_lier
dabbler124012153dabbl_er
dallier84215373da_llier
danglier1056753danglier
darbies104216983darb_ies
daubier1037093daub_ier
drawlier12225253drawlier
earthier1137443earthier
earthlier1244303earthlier
fabler116115813fa_bl_er
farrier103514883far_rier
gabbier12379633ga_bbier
gabbler124013303gabbl_er
gainlier965673gainlier
gambier124711973gamb_ier
gambler123612683gambl_er
ganglier1047603ganglier
garble94118453garbl_e_
garbled114512803garbl_ed
garblers113810283garbl_ers
garbles104016923garbl_es
garbling12249453garbling
gargler93710263gargl_er
gasalier936443gasalier
gaselier946963gaselier
gasolier935833gasolier
girlier8289523gir_lier
gnarlier9255163gnar_lier
grabbier13316653grabbier
hacklier1737133hacklier
harborer1348053harborer
hardier114721543har_dier
harrier104417753har_rier
haulier1059943ha_ulier
herbier1239593herb_ier
janglier1656113janglier
lambier113611643lamb_ier
lardier83518343lar_dier
larkier113711523lar_kier
lavalier1146043lavalier
lordlier935353lordlier
mailer84724183ma_il_er
mainliner1144673mainliner
malmier113611953ma_lmier
maltier93015483ma_ltier
mangier104114063ma_ngier
mangler103215643mangl_er
marauder1144553marauder
marbelize2246113marbelize
marbelized2454613marbelized
marbelizes2345373marbelizes
marbleise1343483marbleise
marbleised1542603marbleised
marbleises1443523marbleises
marbleize2243073marbleize
marbleized2442573marbleized
marbleizes2342943marbleizes
marblings14225533marblings
marbly134111933marbl__y
marceller1345153marceller
marcher143912973mar_cher
mariner93315993mar_iner
marker124420393mar__ker
marketer1437383marketer
marled95523163mar_l_ed
marliest102415183mar_liest
marlin84220903mar_li_n
marline93320953mar_line
marlines103818713mar_lines
marling103322763mar_ling
marlins93420473mar_lins
marlite92917073mar_lite
marlites103415263mar_lites
marrer83716673mar__rer
married104715303mar_ried
marriers103312473mar_riers
marries93825283mar_ries
martlet93419153martl_et
massier93615223ma_ssier
matier84321523ma__tier
mauler84416713ma_ul_er
mayflies1644913mayflies
mazier175013063ma__zier
mealier93015903m_ealier
measlier1036013measlier
merrier92612303mer_rier
millier93716703m_illier
mirier83918363mir__ier
mirkier13319053mir_kier
moralizer2049473moralizer
motlier92010583m_otlier
mumbler133510913mumbl_er
murkier133110263mur_kier
nearlier836793near_lier
nubblier1254413nubblier
orbier839993_orb_ier
palier85023563pa__lier
pallier94417163pa_llier
parrier93717653par_rier
parslied1137803parslied
partier93520713par_tier
pearlier1037313pear_lier
pebblier1453263pebblier
portlier1038373portlier
rabbler113514093rabbl_er
rallier73816273ra_llier
rambler113313263rambl_er
rarefier1135353rarefier
relier65826183__relier
rubblier1244913rubblier
rulier65016353__rulier
sallier73320423sa_llier
sarkier113413313sar_kier
smarmier1235033smar_mier
snarlier8278183snar_lier
sparklier1554353sparklier
surlier72915443sur_lier
tallier72817213ta_llier
tanglier948073tanglier
tardier859719993tar_dier
tarrier74323173tar_rier
tarsier74119253tar_sier
tartier74123263tar_tier
unrulier845333unrulier
varier94619353var__ier
wabbler143511923wabbl_er
wafflier1733953wafflier
wagglier1344323wagglier
warble113516603warbl_e_
warbled133212163warbl_ed
warblers13319103warbl_ers
warbles123215563warbl_es
warbling14198943warbling
warier93722893war__ier
warsler10289893warsl_er
wartier103413913war_tier
wobblier15325203wobblier

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 Filter1786911461620.1701051123.5
2DLD Change Limit1461621886.26623326.2
3Display Results1881880.0762473.7
 (SQL Overall)1786911886.51227440.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.