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

152 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
biestings1226603(None) 
beestings12335921beestings
bastings114214692b_astings
beastings12387652beastings
beatings114113232b_eatings
beeswings15293302beeswings
beltings11369252b_eltings
besting104923922b_esting_
bittings11339292bi_ttings
blastings12347912blastings
blessings1233722blessings
crestings12298042crestings
jestings16368022_jestings
listings93310042li_stings
rieslings1034492rieslings
vestings12359142_vestings
westings12429802_westings
agentings1134443agentings
bashings144311243b_ashings
basting104227203b_asting_
battings114010573b_attings
beadings123711783b_eadings
bearings113912253b_earings
beating104326873b_eating_
beddings13407923b_eddings
beeswing14255763beeswing_
beings94613033b_e__ings
bellings113811153b_ellings
belting104119133b_elting_
bestirs9311133b_esti_rs
betting103921403b_etting_
biasing103512453bias_ing_
biassing11307263biassing_
biddings13397563bi_ddings
bielding12237473bielding_
biggings13327473bi_ggings
bighting15269453bighting_
billings113412633bi_llings
biltongs1133813bi_ltongs
bindings123810473bi_ndings
biotins93114453bi_otin_s
birdings12378823bi_rdings
birlings11359613bi_rlings
birthings15254623birthings
bisecting1436973bisecting_
bitewings1542943bitewings
biting95321823bi__ting_
bitting103717293bi_tting_
blasting114013433blasting_
bleating113514503bleating_
blebbings13242783blebbings
bleedings13264643bleedings
blessing1137593blessing_
boasting113512503boasting_
boatings113710113b_oatings
boosting113311053boosting_
bowstrings16173223bowstrings
breakings16297063breakings
breasting1239583breasting_
breathings16234313breathings
breedings13375763breedings
brewings14296693bre_wings
briefings1543733brie_fings
brislings12236363brislings
buntings11348773b_untings
bursting1138703bursting_
bushings14348793b_ushings
busings103711223b_us_ings
bussings11386663b_ussings
busting104221793b_usting_
castings113614053_castings
coastings12357863coastings
cresting114017043cresting_
destines93619663_destines
dieselings1252933dieselings
dieting93616833die_ting_
digesting12208673digesting_
divesting14298483divesting_
dressings11265373dressings
dustings10419033_dustings
eastings93412953_eastings
eatings84616443__eatings
egesting1039013egesting_
eyestrings1462773eyestrings
fastings124011943_fastings
feltings12317903_feltings
fightings17276503fightings
firstlings1442523firstlings
fishings15307693fi_shings
fisting113818123fi_sting_
fittings12318203fi_ttings
fleshings16335383fleshings
frostings1335733frostings
ghostings1433483ghostings
greetings11276043greetings
guesting1058463guesting_
heisting123411043heisting_
hissings12556753hi_ssings
histing113720373hi_sting_
hustings12378683_hustings
jesting154317713_jesting_
kiltings13327083ki_ltings
lastings94214423_lastings
lightings14277723lightings
listing84020593li_sting_
meetings11287413_meetings
mestinos1048163_mestinos
misting103623383mi_sting_
nesting84320443_nesting_
nestlings1074313_nestlings
nettings9288103_nettings
obtesting1245883obtesting_
pettings11349703_pettings
piecings1345343pie_cings
piercings1453263piercings
pilotings1234353pilotings
pittings11349123pi_ttings
postings112912303_postings
pressings12269023pressings
priesting1239483priesting_
questing1838273questing_
reesting93118273reesting_
resting85031183_resting_
restrings10159293_restrings
riesling939013riesling_
rinsings9318013rins_ings
risings83211893ri_s_ings
seatings93614303_seatings
seisings9398523seis_ings
sestinas8249133_sestinas
sestines82717243_sestines
settings93810073_settings
sheetings13256713sheetings
siftings12236583si_ftings
sightings14256533sightings
sittings9339733si_ttings
stings76220183___stings
sweetings13326183sweetings
testing86021053_testing_
tintings9288713ti_ntings
twistings13264353twistings
vesting114618683_vesting_
viewings1533983vie_wings
waistings1352710763waistings
weltings12388203_weltings
westing115020273_westing_
wettings12348403_wettings
wisting113519743wi_sting_
wittings12328733wi_ttings
wresting123811833wresting_
wrestlings1442933wrestlings
zesting174515333_zesting_

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 Filter1786911486410.406440125.6
2DLD Change Limit1486411526.29623608.8
3Display Results1521520.0632412.7
 (SQL Overall)1786911526.76526414.0
 
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.