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

258 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
burlaps115625(None) 
burlap1098351burlap_
burans85019302bur_ans
buras74736302bur_a_s
bureaus979292bureaus
burglars1154592burglars
burials93612082burials
burkas124513802burka_s
burlers94120272burlers
burleys12479672burleys
burls74228852burl__s
burps94220172bur__ps
burqas174410902burqa_s
bursars94510892bursars
bursas85318272bursa_s
earlaps936392earlaps
auras55932563aur_a_s
balas76937213b_ala_s
ballads104212913ballads
baps86040843b___aps
barcas101016603barca_s
barhops14288113barhops
barless94317003barless
barleys125011843barleys
barlows12259973barlows
becaps123811403b_ecaps
beclasp1335263beclasp
beclasps1444353beclasps
bedlamps1543663bedlamps
bedlams1237053bedlams
beflags1355493beflags
beglads11127263beglads
belays114313853b_elays
beleaps1138053beleaps
berlins93216013berlins
bewraps14135403bewraps
birlers93813003birlers
birles84920643birl_es
birls74023163birl__s
bitmaps1344253bitmaps
blabs95619633b__labs
blahs105616513b__lahs
blams95023853b__lams
blats75132503b__lats
blaws105620463b__laws
blips95615783b__lips
bluecaps1442513bluecaps
bolas74733763b_ola_s
borals86721913bor_als
boras75938303bor_a_s
boreas85421733borea_s
boylas113011723boyla_s
brads85528293b_r_ads
braes75735053b_r_aes
brags85625103b_r_ags
brans75437433b_r_ans
bras65746453b_r_a_s
brass75428023b_r_ass
brats75336013b_r_ats
braws106425193b_r_aws
brays106723113b_r_ays
breads95419203b_reads
breaks124816423b_reaks
breams104815043b_reams
briars84814823b_riars
broads94515153b_roads
brulots946223brulots
bubales113513343bubales
bubalis11359903bubalis
bubals103513843bu_bals
bubbas94110703bubba_s
budless1038873budless
buglers105115323buglers
bugles94822443bugl_es
bugloss1035893bugloss
buhls105111803buhl__s
builds9378493buil_ds
buildups1342033buildups
bulbs96016933bu_l_bs
bulges95919323bu_lges
bulks115920613bu_l_ks
bulla74620563bulla__
bullace113410673bullace
bullaces12299433bullaces
bullae83416163bulla_e
bullate93415073bullate
bullbats1255893bullbats
bullets93516393bullets
bullies94121893bullies
bullous9311663bullous
bulls75629573bu_l_ls
bumps115921143bu__mps
bunas75126573bu_na_s
bunyas11359433bunya_s
bura66139533bur_a__
buran75225303bur_a_n
burblers12399263burblers
burbles114916803burbles
burbots1168673burbots
burbs95423493bur__bs
burdens1039713burdens
burdies104117563burdies
burds84626063bur__ds
bureau8712523burea_u
bureaux1664593bureaux
burets84321263bur_ets
burgage1136633burgage
burgages1236483burgages
burgees104915893burgees
burgers103918573burgers
burgess10409343burgess
burghs12519923bur_ghs
burglar1065533burgla_r
burglary1473133burglary
burgles105615963burgles
burgoos1037123burgoos
burgs84924093bur__gs
burial84117623buria_l
buriers94017193buriers
buries84633273bur_ies
burins84221893bur_ins
burka114617693burka__
burkers133716623burkers
burkes124421313bur_kes
burl64937183burl___
burled94825383burl_ed
burler84723833burl_er
burlesk1335463burlesk
burlesks1443223burlesks
burley114715753burl_ey
burlier93514413burlier
burliest103113063burliest
burlily1237713burlily
burling104421133burling
burly104922833burl__y
burners94115673burners
burnets93813263burnets
burnies94017823burnies
burnous938823burnous
burns74926773bur__ns
burp85028883bur__p_
burqa165013093burqa__
burrers93814493burrers
burros85114993bur_ros
burrows12399093burrows
burrs74925653bur__rs
burs65847423bur___s
bursa74921523bursa__
bursae84515603bursa_e
bursal84414823bursa_l
bursar85413253bursa_r
bursary12397583bursary
bursate94111203bursate
burses84425513bur_ses
bursts85116243bur_sts
burtons9310853burtons
busbars1138153busbars
busloads1144153busloads
butlers94518053butlers
butles84423913butl_es
buttals938503buttals
byelaws1533263byelaws
bylaws14415833b_ylaws
byplays1743103byplays
byrls105711233byrl__s
byroads1335293byroads
claps95626183__claps
courlans10117613courlans
craps95328643_cr_aps
cullays12347703cullays
curlers94218073curlers
curlews12387393curlews
curls74927103curl__s
currans9310613currans
curtals93111623curtals
cutlas8313103cutla_s
cutlass938013cutlass
dewlaps1334663dewlaps
duras65727733dur_a_s
durbars1077973durbars
durians839573durians
durras74713373durra_s
earflaps1342553earflaps
earlap837183earlap_
flaps105621383__flaps
fraps105620553_fr_aps
fullams1236553fullams
furans94515953fur_ans
furlers104214223furlers
furless103210143furless
furls85322053furl__s
gulags837543gu_lags
gulps84715073gu_l_ps
hubcaps1643543hubcaps
hulas84920883hu_la_s
hurlers103714323hurlers
hurleys13407333hurleys
hurlies103315333hurlies
hurls86522713hurl__s
hurrahs13336773hurrahs
hurrays13386153hurrays
jalaps15299183_jalaps
juleps1535623ju_leps
jurats134213203jur_ats
kulaks976113ku_laks
kurgans12145653kurgans
kurtas10349883kurta_s
laps66848873___laps
lurdans837073lurdans
mudcaps1444103mudcaps
mudflaps1641803mudflaps
mullahs12388733mullahs
mullas84215933mulla_s
murals84016763mur_als
muras75329583mur_a_s
murras84916013murra_s
nullahs10316993nullahs
nurls55519683nurl__s
orlops847303_orlops
outlaws10249603outlaws
outlays102610903outlays
outleaps10237073outleaps
overlaps13219523overlaps
parlays123910453parlays
perhaps1446123perhaps
pullups1134233pullups
pulps95116483pu_l_ps
purdahs13285483purdahs
purdas92612263purda_s
purlins93415423purlins
purls74723353purl__s
raps66247733__r_aps
reaps75626193__reaps
scraps106017243scr_aps
slaps76025713__slaps
straps87721783str_aps
sunlamps1243293sunlamps
surahs94515543sur_ahs
suras55336333sur_a_s
surpass938283surpass
surras65919533surra_s
threaps12488643threaps
traps75727483_tr_aps
tulips8137253tu_lips
turbans939563turbans
turnips935013turnips
turnups933893turnups
turps74918733tur__ps
uhlans937573_uhlans
ulans54921303_u_lans
uncaps1039813_uncaps
unlays93810493_unlays
upleaps1185233_upleaps
ureas55826013_urea_s
urials64415193_urials
urps66920473_ur__ps
wraps105617153_wr_aps
yulans958673yu_lans

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.390458182.1
2DLD Change Limit1340272586.90619407.3
3Display Results2582580.0932774.2
 (SQL Overall)1786912587.38924183.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.