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

57 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
breakages164428(None) 
breakage1544181breakage_
brakeages1643972br_akeages
breakables1842752breakables
brewages1436382bre_wages
brockages1844782brockages
brokages1536252br_okages
leakages1334932_leakages
wreckages1942772wreckages
arrearages1143033arrearages
berakes134815773berak__es
blockages1844063blockages
boskages1565423b_oskages
brakeage1544013br_akeage_
brakes124923123br_ak__es
brassages1245263brassages
breaches153714123brea_ches
breakable1746163breakable
breakaway2151533breakaway
breakaways2251363breakaways
breaker133912923break__er
breakers143810973break_ers
breakeven1841803breakeven
breakevens1951223breakevens
breakfasts1952053breakfasts
breakings16297063breakings
breakouts1553833breakouts
breaks124816423break___s
breakups1642513break_ups
breakwalls1951883breakwalls
breakwater1952583breakwater
breakwaters2062183breakwaters
breathes134212903brea_thes
brewage1347183bre_wage_
broadaxes1943733broadaxes
brockage1744743brockage_
brokage1436673br_okage_
bulkages1535273b_ulkages
cleavages1542863cleavages
creepages1444303creepages
drayages1344503dr_ayages
dressages1144153dressages
leafages1244623_leafages
leakage1235003_leakage_
prepackages2252083prepackages
presages11312203pre_sages
ravages1139403_r_avages
reawakes15348073_reawakes
redamages1344303_redamages
reimages1138373_reimages
repackages1942613_repackages
restages92815773_restages
soakages1336143_soakages
stealages1046043stealages
trackages1645343trackages
truckages1643523truckages
wreckage1842763wreckage_

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.1561145455.1
2DLD Change Limit148641577.12620859.0
3Display Results57570.0301900.0
 (SQL Overall)178691577.31224438.0
 
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.