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

67 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
valuably164471(None) 
valuable1336861valuable
evaluable1444232evaluable
invaluably1854122invaluably
palpably1745362palpably
salably121610742sal_ably
saleably1338212saleably
salvably1645442salvably
valuables1442972valuables
variably1637432variably
volubly1543552volu_bly
affably1855183_affably
amiably1438303_amiably
arguably1444503arguably
availably1743253availably
avowably1944003avowably
blamably1744903blamably
callable12310753callable
capably1639253ca_pably
casually1356823casually
culpably1744313culpably
damnably1645113damnably
equably2136183_equably
fallibly1644393fallibly
gullably1444793gullably
invaluable1545073invaluable
issuably1344963issuably
laudably1445123laudably
malleably1674213malleably
manually1347043manually
palatably1644443palatably
palpable1448033palpable
passably1537253passably
payably17177093pa_yably
placably17156673placably
pliably14147383_pliably
ratably121711513ra_tably
rateably1337783rateably
reliably1339243reliably
salable91415463sal_able
saleable10312023saleable
salvable1338403salvable
satiably1337823satiably
scalably15166703scal_ably
solubly1255283solu_bly
suably112814533__suably
talkable1437193talkable
taxably1936043ta_xably
vagally1435833va_gally
vaguely1443693vagu_ely
valiancy1674813valiancy
valiantly1544183valiantly
validly1435573val_idly
valuate102512733valua_te
valuated12239203valuated
valuates112811193valuates
valuator1196723valuator
valval12398863valva_l_
variable13310063variable
viably14199833v__iably
violably1644923violably
visually1465493visually
vocably17157153v_ocably
voluble1244503volu_ble
vulgarly1543163vulgarly
walkable1736063walkable
wallaby1535073wallab_y

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 Filter1786911461620.1531167915.0
2DLD Change Limit146162678.45317291.1
3Display Results67670.0332030.3
 (SQL Overall)178691678.63920684.2
 
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.