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

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

32 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
biofoulings17591(None) 
biofouling1641821biofouling_
befouling1534983b_efouling_
biofoulers1551493biofoul_ers
foulings12327943___foulings
batfowling1942444batfowling_
befooling1535054b_efooling_
bigfooting1741914bigfooting_
billings113412634bi___llings
biofouler1441894biofoul__er
biosolids1242944bioso_li_ds
biotoxins1844184bioto_xin_s
birlings11359614bi___rlings
bloodings13245274blo_o_dings
bloodlines1344184blo_odlines
bobolinks1742494b_obo_links
boodling121910244b_o_odling_
bookings15358734b_o_o_kings
bottlings12215294b_o_ttlings
botulins1047064b_o_tulin_s
botulinus1142754b_o_tulinus
bowlings14408754b___owlings
cohousings1642124_cohousings
fouling113315374___fouling_
fowlings15377244___fowlings
inpourings1342444_inpourings
insouling1036824_insouling_
profilings1653564prof_ilings
riflings12227304ri_f__lings
spoolings12245394spo_o_lings
toolings9248474_to_o_lings
wildfowlings236714wildfowlings

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 Filter1786911488190.453394461.4
2DLD Change Limit148819328.37317773.7
3Display Results32320.0162000.0
 (SQL Overall)178691328.84220209.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.