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

147 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
burglar106553(None) 
burglars1154591burglars
burglary1473131burglary
bugler94717722bu_gler
bungler104611482bungler
burbler114412422burbler
burger94020792burg_er
burghal1335072burghal
burgher1337002burgher
burgle94815862burgl_e
burgled115511422burgled
burgles105615962burgles
burlap1098352bur_lap
burler84723832bur_ler
bursar85413252bur_sar
aurar54420253aur__ar
basilar937303basilar
beggar10328223b_eggar
beglad10138463b_eglad
bifilar1244043bifilar
bipolar1145453bipolar
birler85715083bir_ler
boggler113910083boggler
bolar75123473b__olar
briar75718153b_r_iar
bubbler103611783bubbler
buckler154112033buckler
budger104617703budg_er
bugbear1233953bugbear
bugger104418723bu_gger
buggier113611343buggier
bugle84721943bu_gl_e
bugled104918133bu_gled
buglers105115323bu_glers
bugles94822443bu_gles
bulbar1039583bu_lbar
bulger94917353bulg_er
bulghur1352723bulghur
bulgier103911213bulgier
bulgur9387533bulg_ur
bulla74620563bu_lla_
bullae83416163bu_llae
bumbler134013233bumbler
bundler104011723bundler
bungle97116113bungl_e
bungled114112243bungled
bunglers11398483bunglers
bungles104116763bungles
bura66139533bur__a_
buran75225303bur__an
buras74736293bur__as
burble104617703burbl_e
burbled124312673burbled
burblers12399263burblers
burbles114916803burbles
burblier1255603burblier
burbly134311153burbl_y
bureau8712523bur_eau
burg74930363burg___
burgage1136633burgage
burgee97120593burg_ee
burgees104915893burgees
burgeon1036433burgeon
burgers103918573burgers
burgess10409343burgess
burgh115216033burg__h
burghers1435633burghers
burghs12519923burg_hs
burglaries1344193burglaries
burglarize2252723burglarize
burgling12239303burgling
burgoo938933burg_oo
burgoos1037123burgoos
burgout1049773burgout
burgrave1443113burgrave
burgs84924093burg__s
burial84117623bur_ial
burials93612083burials
burier84324653bur_ier
burka114617693bur_ka_
burkas124513803bur_kas
burker125221173bur_ker
burl64937183bur_l__
burlaps1156253bur_laps
burled94825383bur_led
burlers94120273bur_lers
burley114715753bur_ley
burlier93514413burlier
burls74228853bur_l_s
burly104922833bur_l_y
burner83819203bur_ner
burqa165013093bur_qa_
burqas174410903bur_qas
burr65631233bur___r
burrer83718473bur_rer
burrier93613553burrier
bursa74921523bur_sa_
bursae84515603bur_sae
bursal84414823bur_sal
bursars94510893bur_sars
bursary12397583bur_sary
bursas85318273bur_sas
bursera936763bursera
burster9310293burster
busbar1038453bu_sbar
bustler94012563bustler
butler84220033bu_tler
cupular11317623cupular
curdler103511563curdler
curler85221323cur_ler
durbar968723dur_bar
furcular1345703furcular
furler93616403fur_ler
gargler93710263gargler
gular6314833gu__lar
gurgle83912473gurgl_e
gurgled10399123gurgled
gurgles94312873gurgles
gurglet94412033gurglet
hurdler113610003hurdler
hurler94717223hur_ler
juggler16418873juggler
jugular1534513jugular
kurgan11126783kurg_an
lunular736013lunular
morular978223morular
muggar10316443mu_ggar
mutular936643mutular
neurular844003neurular
outglare937383outglare
pupilar11125313pupilar
purfler12248733purfler
purger94717233purg_er
purpler11289263purpler
subalar9118073subalar
sugar6312913su_g_ar
surger74320093surg_er
tubular9267473tubular
tumular9236543tumular
turgor736863turg_or
turtler72610323turtler
tutelar735373tutelar
ungular836773_ungular
urger64116473_urg_er
uvular955563_uvular
verglas1137813verglas
vulgar10426823vulg_ar

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271476.37621020.5
3Display Results1471470.0602450.0
 (SQL Overall)1786911476.59227107.3
 
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.