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

75 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
loosening104493(None) 
lessening1045332lessening
loosing83515962loos__ing
loudening1144742loudening
unloosening1251562unloosening
worsening1345552worsening
boogeying1643623boogeying
boosting113311053boos_ting
closeting1236183closeting
coarsening1345543coarsening
consenting13313223consenting
convening15311193convening
cooeeing1137453coo_eeing
cooeying1438143coo_eying
coopering142611323coopering
corseting12312173corseting
cosseting1239543cosseting
cozening20188303_cozening
dovening13238353_dovening
dozening19236183_dozening
goosing93314083goos__ing
hoarsening1444403hoarsening
hoidening1435633hoidening
hoovering1635753hoovering
hoseying1537193_hoseying
houseling1337483houseling
hoydening1744353hoydening
ladening1078823l_adening
latening9711493l_atening
leadening1176733leadening
leavening1365973leavening
lessoning1044773lessoning
lichening1545673lichening
likening13246893l_ikening
lippening14234943lippening
listening10128953listening
livening12248153l_ivening
loaning83614833l_o_aning
lobstering1345123lobstering
loitering1039683loitering
longeing10177593longe_ing
looing73621043loo___ing
looking123415043loo__king
looming102814853loo__ming
looping103615283loo__ping
loosen66615963loose__n_
loosened945453loosen_ed
loosener845633loosen_er
looseners945403looseners
looseness937473looseness
loosens716310953loose__ns
looting83019643loo__ting
loppering14237283loppering
losing74022873l_os__ing
lousing83817733lous__ing
lowering122210913l_owering
moistening1346233moistening
mooning103415553moo__ning
morseling1238073morseling
moseying1436853_moseying
nooning83014853noo__ning
noosing83315053noos__ing
omening10310093__omening
opening1039923__opening
poisoning1245903poisoning
pollening1236923pollening
reopening1248823reopening
roosing84018133roos__ing
roosting93411463roos_ting
rosining92411423_rosining
soddening1244543soddening
softening1365493softening
tokening1336463_tokening
wooshing1536683woos_hing
zooning172910703zoo__ning

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.436409841.7
2DLD Change Limit148641757.17320722.3
3Display Results75750.0302500.0
 (SQL Overall)178691757.63923391.9
 
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.