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 “bouldering” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

59 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
bouldering146476(None) 
mouldering1474281mouldering
blundering1444822blundering
bordering1338832bo_rdering
foundering1545352foundering
moldering1367862mo_ldering
shouldering1662342shouldering
smouldering1572172smouldering
soldering1169032so_ldering
bewildering1872703bewildering
blubbering14103443blubbering
blustering13106183blustering
bolstering1346883bolstering
bothering152210203bo_thering
boulder103411343boulder___
bouldered1344483boulder_ed
boulderer1244403boulder_er
boulderers1343663boulderers
boulders113010033boulder__s
bouldery14295013boulder__y
bounderish1643173bounderish
bounding123012133bound__ing
bowering142911713bo__wering
broidering1444673broidering
buffering1835223b_uffering
buggering1435193b_uggering
bulleting1236643b_ulleting
bullring11388423b_ul_lring
bumpering1636593b_umpering
bunkering16207103b_unkering
burdening1335543b_urdening
buttering122312523b_uttering
countering13314473countering
daundering1364463daundering
doddering1335183do_ddering
floundering1642483floundering
foddering1535163fo_ddering
fullering1336653_fullering
hollering1337743ho_llering
juddering1933763_juddering
laundering1245183laundering
loudening1144743lou_dening
maundering1455353maundering
moulding12258143mould__ing
murdering1357133_murdering
ordering1039353_o_rdering
outdaring1179723_outdaring
plundering1444173plundering
pondering132411333po_ndering
powdering16246503po_wdering
shuddering1643513shuddering
smoldering1474103smoldering
soldiering1244243so_ldiering
sundering11312323_sundering
thundering1544573thundering
ulcering1139333__ulcering
vouchering1943653vouchering
wildering1456743_wildering
wondering142110463wo_ndering

Search took 10 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 Filter1786911406030.423422437.4
2DLD Change Limit140603598.56316419.8
3Display Results59590.0301966.7
 (SQL Overall)178691599.01619819.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.