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

118 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
beginning134461(None) 
beginnings1441701beginnings
begirding1434332begirding
binning103615452b__inning
ginning93313982__ginning
rebeginning1541982rebeginning
repinning12258972repinning
rewinning13257442rewinning
banning103818233b__anning
beaconing1436633beaconing
beaning103820683be__aning
beckoning1845773beckoning
bedamning1534183bedamning
bedimming1743643bedimming
bedizening2392663bedizening
beduncing1543913beduncing
beelining1236593beelining
befitting15236623befitting
befringing1744063befringing
begalling13216493begalling
begazing2136633beg_azing
begetting13186583begetting
beggaring1435183beggaring
begging123012653beg__ging
beginner1173953beginn_er
beginners1283613beginners
begirdling1542193begirdling
begriming1545533begriming
begrimming1842573begrimming
begroaning14114113begroaning
beguiling1334853beguiling
begulfing1642843begulfing
bekissing1643503bekissing
believing1535283believing
belonging1335913belonging
bemeaning1436193bemeaning
bemingling1643403bemingling
bemiring13239603bemi_ring
bemisting1438073bemisting
bemixing20226523bemi_xing
bemoaning1435953bemoaning
bending114420893be__nding
bepainting15144883bepainting
beriming13310463beri_ming
besieging1344763besieging
bethinking2044043bethinking
betiding1239913beti_ding
bewigging1743443bewigging
binding113819383b__inding
binging113619383b__inging
blinding123210163b_linding
blinking153510623b_linking
boinking15378423b_oinking
braining113414683brai_ning
branning112911093b_ranning
bringing123011273b_ringing
brining103216473b_ri_ning
bylining1446013byli_ning
chinning14329653_chinning
defining133711803defi_ning
deigning1137753de_igning
denning93515173de__nning
designing1236623designing
dezincing2244183dezincing
dinning93416553__dinning
engining1039293engi_ning
evincing1446183_evincing
feigning1335813fe_igning
feinting123410833fe_inting
finning113615113__finning
ginnings10366523__ginnings
girning93210693__girning
grinning1037863_grinning
gunning93413173__gunning
inning73617633___inning
kenning124010543ke__nning
lesioning1046443lesioning
misbeginning1851683misbeginning
peining104619153pe_i_ning
penning103616493pe__nning
pinning103417853__pinning
rebinding13249483rebinding
reconning121410793reconning
redonning11127643redonning
refinding14259943refinding
refining122416863refi_ning
regaining112411083regaining
regilding1236123regilding
regiving13269713regi_ving
regrinding1335703regrinding
rehinging1437453rehinging
reigning1039883re_igning
reining84425323re_i_ning
reinking13311023re_inking
relining93218743reli_ning
relinking1458253relinking
remanning12229033remanning
reminding132311543reminding
reminting122315103reminting
repining114116593repi_ning
rerunning1036523rerunning
resigning1139463resigning
resining92919553resi_ning
retinting102215253retinting
rewinding14238933rewinding
rinning83216743__rinning
seining84020773se_i_ning
shinning123211023_shinning
sinning83918443__sinning
skinning13327893_skinning
spinning113310813_spinning
thinning12319093_thinning
tinning83117283__tinning
twinning12367043_twinning
unpinning1245623unpinning
veining114713893ve_i_ning
winning113516553__winning
yenning11369493ye__nning

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.453394461.4
2DLD Change Limit1486411187.19020673.3
3Display Results1181180.0601966.7
 (SQL Overall)1786911187.70323197.6
 
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.