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

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

48 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
boatbuildings199115(None) 
boatbuilding1881601boatbuilding_
bodybuildings236952bodybuildings
outbuildings1651442_outbuildings
boatbuilders1761103boatbuild_ers
bodybuilding2261293bodybuilding_
outbuilding1543543_outbuilding_
abuilding1343564__a_building_
boatbuilder1661124boatbuild__er
bookbindings2271444bookb_indings
buildings1334254____buildings
nonbuilding1552554no_nbuilding_
shipbuildings226684shipbuildings
babblings13194375b_a_b_bl_ings
bearbaitings1751195bearbai_tings
boardings13296065boa____rdings
boardsailings176935boardsail_ings
boatbills1344175boatb_il___ls
boatings113710115boat_____ings
boatlifting1751995boat_lifting_
bobtailing1543515bobt_ail_ing_
bodybuilders216955bodybuild_ers
bookbinding2162085bookb_inding_
bottlings12215295bo_t__tl_ings
botulins1047065bo_t_u_l_in_s
botulinus1142755bo_t_u_l_inus
braidings13285905bra___i_dings
bramblings1742615bramb__l_ings
building1237505____building_
misbuilding1742735_misbuilding_
mouldings13273955mo___u_ldings
multibuilding1961345multibuilding_
outbidding1544635_outb_idding_
outbreedings1661745_outbreedings
outbuilds1243115_outbuild___s
outbulging1444325_outbu_lging_
outbulking1744495_outbu_lking_
outbullying1752295_outbullying_
outguiding1344735_outgui_ding_
overbuilding1943795overbuilding_
pathfindings2261135_pathfindings
potboiling1544125po_tboil_ing_
prebuilding1742385_prebuilding_
rebuilding1443635__rebuilding_
roadholdings186995roa_dholdings
shipbuilding216965shipbuilding_
unbuilding1443675__unbuilding_
upbuilding1642075__upbuilding_

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 Filter1786911247900.483369960.7
2DLD Change Limit124790488.47014733.2
3Display Results48480.0301600.0
 (SQL Overall)178691488.98319892.1
 
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.