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

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

72 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
blatting11411165(None) 
batting104422271b_atting
blasting114013431blasting
blotting113910431blotting
flatting123511251flatting
platting114813031platting
slatting94014231slatting
ablating11311992abla_ting
baiting103918882b_aiting
basting104227202b_asting
bathing134816242b_athing
bating95132252b_a_ting
battings114010572b_attings
battling113110492b_attling
batwing13509812b_atwing
beating104326872bea_ting
betting103921402b_etting
bitting103717292b_itting
blabbing12266722blabbing
blacking174213602blacking
blading113615362bla_ding
blagging13319162blagging
blaming123515692bla_ming
blanking154411932blanking
blaring104317112bla_ring
blastings12347912blastings
blattering13108712blattering
blawing134012752bla_wing
blazing193612392bla_zing
bleating113514502bleating
blitzing2035902blitzing
bloating113512812bloating
blunting11319842blunting
blurting11258772blurting
boasting113512502boasting
boating103721302boa_ting
brattling1236002brattling
butting103519282b_utting
catting103922642_catting
chatting142810142chatting
clotting113110642clotting
dratting10389652dratting
elating83423082ela_ting
fatting113818702_fatting
flatling123410012flatling
flitting123010882flitting
glutting10247642glutting
hatting113920232_hatting
lasting84725242_lasting
lathing114315692_lathing
lattin64316222_lattin_
lattins74115482_lattins
letting83218532_letting
lotting82917752_lotting
matting103620142_matting
patting103722342_patting
plaiting113113512plaiting
planting113515382planting
plating103823072pla_ting
plotting113011012plotting
ratting83822362_ratting
scatting113311812scatting
slanting94115092slanting
slating83724652sla_ting
slattings10346072slattings
slitting93012582slitting
slotting92612612slotting
spatting113111762spatting
splatting1235982splatting
swatting12309592swatting
tatting84019522_tatting
vatting113614852_vatting

Search took 4 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 Filter1786911210590.390458182.1
2DLD Change Limit121059723.39335679.0
3Display Results72720.0302400.0
 (SQL Overall)178691723.81346863.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.