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

127 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
buildings133425(None) 
building1237501building_
abuilding1343562abuilding_
biddings13397562b_iddings
billings113412632b_illings
bindings123810472b_indings
birdings12378822b_irdings
buddings13326652bu_ddings
bullrings12314622bullrings
bundlings13235562bundlings
gildings11356972_gildings
hildings13347502_hildings
quillings19225742quillings
quiltings19214682quiltings
wildings13287932_wildings
audings9289393au__dings
bailing103723523bail_ing_
balding114015063b_alding_
beadings123711783b_eadings
beddings13407923b_eddings
bellings113811153b_ellings
beltings11369253b_eltings
bidding123613513b_idding_
biding104720793b_i_ding_
bielding12237473bielding_
biggings13327473b_iggings
bilging114212683b_ilging_
bilking144413553b_ilking_
billing103823853b_illing_
biltongs1133813b_iltongs
binding113819383b_inding_
birding114014923b_irding_
birlings11359613b_irlings
bittings11339293b_ittings
bladings12337753b_ladings
bleedings13264643bleedings
blinding123210163blinding_
bloodings13245273bloodings
bluings10327963b__luings
boardings13296063boardings
bodings113711653b__odings
boiling103819673boil_ing_
bondings12369413b_ondings
bowlings14408753bowl_ings
braidings13285903braidings
brandings13277483brandings
breedings13375763breedings
bridgings14254293bridgings
bridling122610583bridling_
briefings1543733briefings
brislings12236363brislings
budding123712403bu_dding_
bugling113615343bugl_ing_
builders1146743build_ers
builds9378493build___s
buildups1342033build_ups
bulging113514213bu_lging_
bulking143815123bu_lking_
bulldogs1274243bulld_ogs
bulling104324793bu_lling_
bullring11388423bullring_
bullying14329293bullying_
bumblings16194753bumblings
bundling12219703bundling_
bunglings13235213bunglings
buntings11348773bu_ntings
burling104421133burl_ing_
burnings11387623bu_rnings
bushings14348793bu_shings
busings103711223bu__sings
bussings11386663bu_ssings
butling103516813butl_ing_
ceilings11397993ceil_ings
childing15288503childing_
curlings114110383curl_ings
drillings11285823drillings
evildoings154843evildoings
failings123811013fail_ings
filings115213073_fil_ings
fillings122910503_fillings
findings13328443_findings
frillings13265803frillings
geldings11316163_geldings
gilding103813003_gilding_
guiding102911843gui_ding_
guiling93214213guil_ing_
hidings12349703_hi_dings
hilding123713533_hilding_
holdings13297743_holdings
hurlings12388213hurl_ings
killings133710483_killings
kiltings13327083_kiltings
mailings113011923mail_ings
milding113615453_milding_
millings113712583_millings
moldings12267203_moldings
mouldings13273953mouldings
outbuildings1651443outbuildings
pilings103313613_pil_ings
puddings13325503pu_ddings
puddlings14243793puddlings
pulings103511323pu_l_ings
purlings113910283purl_ings
quilling182510003quilling_
quilting18218713quilting_
quislings19184713quislings
railings93412153rail_ings
rebuilding1443633rebuilding_
ridings93412093_ri_dings
rulings83310383ru_l_ings
sailings93513253sail_ings
scoldings13224133scoldings
shillings13348093shillings
sidings94011463_si_dings
skillings14246133skillings
spilings11308813spil_ings
suitings9288953sui_tings
tailings93211673tail_ings
tidings93810263_ti_dings
tilings84212793_til_ings
twillings13234913twillings
unbuilding1443673unbuilding_
upbuilding1642073upbuilding_
veilings12357313veil_ings
wilding123814293_wilding_
wildlings14244923_wildlings
windings13329973_windings

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 Filter1786911486410.406440125.6
2DLD Change Limit1486411277.36020195.8
3Display Results1271270.0462760.9
 (SQL Overall)1786911277.81222873.9
 
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.