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

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

80 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
imaginative175384(None) 
imagination1447192imagination
imaginatively2262372imaginatively
unimaginative1961812unimaginative
agitative1346873__agitative
emanative1447313ema__native
imaginable1544293imagina_ble
imaginaries1453723imaginaries
imaginarily1751983imaginarily
imaginations1546343imaginations
imitative1446333im__itative
implicative2054663implicative
originative1553933originative
agentive1248044__agen_tive
carminative1844894carminative
cogitative1645934_cogitative
combinative2055134combinative
designative1654334designative
diminutive1653394dim__inutive
dominative1677394_dominative
eliminative1654364eliminative
emarginate1385454emarginat__e
emargination1554864emargination
evaginate1376484evaginat__e
evaginating1644914evaginating
evagination1546564evagination
germinative1755044germinative
gravitative1852974gravitative
illuminative1763244illuminative
imaginably1853544imagina_bly
imaginal1144904imagina___l
imaginariness16152004imaginariness
imaginary1552504imagina__ry
imaginativeness21152534imaginativeness
imagine1037884imagin____e
imagining1345414imagin__ing
imagistic1445114imagi_sti_c
imperative1748564im_perative
imputative1744484im_putative
indicative1647714i_ndicative
infinitive1645344i_nfinitive
initiative1346904initi_ative
insinuative1454024i_nsinuative
instigative1555124instigative
instinctive1654374instinctive
invaginate1445054invaginat__e
invaginating1753904invaginating
invagination1645644invagination
irradiative1552894irradi_ative
irritative1345204i_rritative
limitative1544694lim__itative
magnate10512704_mag_nat__e
magnetise125110404_mag_netise
magnetite127311214_mag_netite
magnetize21519874_mag_netize
marginalize2364214_marginalize
marginate12179604_marginat__e
marginating1545894_marginating
margination1447434_margination
marinate103017784_marinat__e
marinating13410274_marinating
marination12312814_marination
mediative1548124_medi_ative
meditative1646284_meditative
mitigative1644094_mitigative
motivative1844284_motivative
nominative1597684_nominative
overimaginative2471334overimaginative
paginate114012444_paginat__e
paginating1447534_paginating
pagination1348994_pagination
plaintive1444624pla_in_tive
qualitative2353194qualitative
radiative1348174_radi_ative
ruminative1546434_ruminative
sanative11310474_sa__native
terminative1656134terminative
unimaginatively2481064unimaginatively
urinative1247654__urinative
vaginate123911084_vaginat__e

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 Filter1786911488190.423422437.4
2DLD Change Limit148819808.51617475.2
3Display Results80800.0302666.7
 (SQL Overall)178691808.96919923.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.