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

49 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
standoffishness25763(None) 
sniffishness2152194s__n_iffishness
standoffish2161344standoffish____
standoffishly267674standoffish__ly
offishness1943795_____offishness
raffishness2043375_ra___ffishness
sandfishes1745545s_and__fish_e_s
snobbishness1952095s__n_obbishness
standishes1445715stand___ish_e_s
caddishness1843416_ca_d__dishness
candlefishes2152006_candlefish_e_s
clannishness1752816clan___nishness
doggishness1793476____doggishness
dollishness1544016____dollishness
doltishness1544216____doltishness
donnishness1543896____donnishness
dovishness1744466____do_vishness
dwarfishness2292026dwa___rfishness
faddishness1943246_fa_d__dishness
fiendishness1952336fiend___ishness
mannishness1643976_man___nishness
oafishness1644466_____oafishness
outlandishness186596outland___ishness
prankishness2153056pran___kishness
sandiness102111716s_and___i__ness
scandalousness1792146scandalous_ness
selfishness1743816s____elfishness
shadowiness1842116sha_do_wi__ness
slanderousness1563026slanderous_ness
slavishness1753706sla____vishness
snappishness1952286s__n_appishness
sniffiness1643766s__n_iffi__ness
sniffishnesses2272206s__n_iffishnesses
sottishness1444436s____ottishness
spadefishes2052696spa_d_efish_e_s
standardises14213086standardis__e_s
standoffs1642676standoff______s
starfishes1646156sta___rfish_e_s
steadfastness176856stead__fastness
stonefishes1753716ston__efish_e_s
studfishes17103796st_ud__fish_e_s
stuffiness1643696st___uffi__ness
stylishness1743446st____ylishness
swainishness1852296swa___inishness
swinishness1743576swin____ishness
tomboyishness236866_tombo_yishness
unselfishness1991416__unselfishness
vaporishness2052316_va_po_rishness
wolfishness2043736____wolfishness

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 Filter178691950240.356501941.0
2DLD Change Limit95024497.90612019.2
3Display Results49490.0331484.8
 (SQL Overall)178691498.29521542.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.