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

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

41 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
unimaginative196181(None) 
imaginative1753842__imaginative
unimaginatively2481062unimaginatively
unimaginable1753073unimagina_ble
eliminative1654364elim__inative
imagination1447194__imagination
imaginatively2262374__imaginatively
nominative1597684_nom__inative
originative1553934ori__ginative
overimaginative2471334overimaginative
unimaginably2062344unimagina_bly
agitative1346875____agitative
animalization2448895animalization
carminative1844895carm__inative
combinative2055135_com_binative
contaminative2054375contaminative
denominative1854405denom__inative
diminutive1653395_dim__inutive
dominative1677395_dom__inative
emanative1447315__ema__native
germinative1755045germ__inative
imaginable1544295__imagina_ble
imaginaries1453725__imaginaries
imaginarily1751985__imaginarily
imaginations1546345__imaginations
imitative1446335__im__itative
implicative2054665__implicative
initiative1346905ini__ti_ative
invaginate1445055in_vaginat__e
invaginating1753905in_vaginating
invagination1645645in_vagination
limitative1544695_lim__itative
niacinamide16101575_ni_acinamide
nominatives1694775_nom__inatives
nonimitative1784545nonim__itative
ruminative1546435_rum__inative
terminative1656135term__inative
uninformative2162235uninformative
uninventive1752475uni_nven_tive
univariate1354125univari_at__e
urinative1247655u____rinative

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 Filter1786911247900.390458182.1
2DLD Change Limit124790419.36013332.3
3Display Results41410.0162562.5
 (SQL Overall)178691419.76618297.3
 
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.