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

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

62 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
disfurnishments247199(None) 
disfurnishment2372081disfurnishment_
disfurnishes1951873disfurnish_e__s
diminishments2162964di__minishments
disbursements1853914disbur__sements
disfurnished2051664disfurnish_e__d
disfurnishing2161584disfurnish_in_g
disguisements1763934disgu__isements
refurbishments2461954_refurbishments
astonishments1872545_as_tonishments
diminishment2063595di__minishment_
disburdenments2062505disbur_denments
disbursement1754445disbur__sement_
discernments1785195discern___ments
disfurnish1752645disfurnish_____
disgruntlements19112025disgruntlements
disguisement1654445disgu__isement_
garnishments1873335___garnishments
nourishments1753695__nour_ishments
punishments1853445___pu_nishments
refurbishment2362155_refurbishment_
admonishments2162546__admonishments
astonishment1762916_as_tonishment_
banishments1864296____banishments
demolishments21122996d__emolishments
despisements1785166des___pisements
disagreements1763646disagr__eements
disappointments22111996disappointments
disarmaments1763946dis_ar__maments
disarrangements1972696disarrangements
disbandments1853436dis_ban__dments
disbarments1654936disbar____ments
disburdenment1962716disbur_denment_
discernment16116116discern___ment_
discouragements21182806discour_agements
disendowments20112976dis__endowments
disfigurements21132146disf_igurements
disgruntlement18132096disgruntlement_
disinterments1664856dis__interments
disinvestments2063036dis_investments
dismantlements19103006dis_mantlements
disorients1177786dis_or_i___ents
disownments17114906dis_own___ments
disparagements2063476dispar_agements
disportments1755356dispor___tments
dissepiments1753466dis_sepi__ments
divertissements21102016di_vertissements
establishments21132236_establishments
famishments2153386___f_amishments
furnishers1643636___furnish_e_rs
furnishes1536236___furnish_e__s
furnishings1852026___furnish_ings
garnishment1774376___garnishment_
infringements1963356_inf_ringements
inurnments1245936_i_nurn___ments
languishments1962276langu__ishments
nourishment1654456__nour_ishment_
punishment1754546___pu_nishment_
refreshments2053606_ref_r_eshments
refurnishes17102996_refurnish_e__s
replenishments2191996_replenishments
stablishments20132496__stablishments

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 Filter178691950240.1231452772.4
2DLD Change Limit95024628.83010761.5
3Display Results62620.0461347.8
 (SQL Overall)178691628.99919856.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.