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

102 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
burghal133507(None) 
burgh115216032burgh__
burgher1337002burgher
burghs12519922burgh_s
burglar1065532burglar
burial84117622bur_ial
bursal84414822bur_sal
mughal1236262mu_ghal
argal65023383_arg_al
aural54428963aur__al
auroral7310473auroral
barbal104016663bar_bal
barchan1469133barchan
benthal1247953benthal
bertha11429173bertha_
berthas12398763berthas
boral75831703bor__al
boreal84817213bor_eal
borstal939043borstal
bridal9511453b_ridal
bromal10313653b_romal
brugh115414293brugh__
brughs12509063brugh_s
brumal1049503b_rumal
brutal859383b_rutal
bubal94218213bu__bal
buccal1248243bu_ccal
buddha1333173buddha_
buddhas1463263buddhas
bugsha1233823bugsha_
bugshas1334513bugshas
buhl95518223bu__h_l
bulghur1352723bulghur
bunghole1444183bunghole
buqsha2032793buqsha_
buqshas2143573buqshas
bura66139533bur__a_
buran75225303bur__an
buras74736293bur__as
bureau8712523bur_eau
burg74930363burg___
burgage1136633burgage
burgee97120593burg_ee
burgees104915893burgees
burgeon1036433burgeon
burger94020793burg_er
burgers103918573burgers
burgess10409343burgess
burghers1435633burghers
burglars1154593burglars
burglary1473133burglary
burgle94815863burg_le
burgled115511423burgled
burgles105615963burgles
burgoo938933burg_oo
burgoos1037123burgoos
burgout1049773burgout
burgrave1443113burgrave
burgs84924093burg__s
burials93612083bur_ials
burka114617693bur_ka_
burkas124513803bur_kas
burl64937183bur___l
burlap1098353bur_lap
burqa165013093bur_qa_
burqas174410903bur_qas
bursa74921523bur_sa_
bursae84515603bur_sae
bursar85413253bur_sar
bursas85318273bur_sas
burthen1236363burthen
busgirl1044143busgirl
bushel114513943bu_shel
butyral1245713butyral
curial84019153cur_ial
curtal83914543cur_tal
dural64923893dur__al
frugal1036393frug_al
fugal95613033fu_g_al
fungal10388733fung_al
jugal135612403ju_g_al
jural125120483jur__al
kurgan11126783kurg_an
marshal1238973marshal
mughals1355753mu_ghals
mural75225103mur__al
murrha11366453murrha_
murrhas12286163murrhas
narwhal1344333narwhal
nuchal11218873nu_chal
rugal65916093ru_g_al
rural55821173rur__al
subgoal1046323subgoal
sural55931263sur__al
surgical1146253surgical
surreal739223surreal
tergal72912833terg_al
turnhall1143043turnhall
ungual738183_ungual
ureal56722683_ur_eal
urial54823023_ur_ial
urinal6614123_urinal

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.1561145455.1
2DLD Change Limit1340271028.29616155.6
3Display Results1021020.0303400.0
 (SQL Overall)1786911028.48221067.1
 
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.