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

84 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
importances175429(None) 
importance1654791importance_
importancies1853271importancies
importancy1953522importanc_y
importunes1444472importun_es
impotences1645572impo_tences
portances1349832__portances
ignorances1344343ignor_ances
immittances1752453immittances
impedances1744503imp_edances
importable1646553importable_
important1346723importan__t
importantly1853243importantly
importune1344773importun_e_
importuned1542893importun_ed
importuner1452683importun_er
importuners1552373importuners
impotence1545793impo_tence_
impotencies1754583impo_tencies
portance12310123__portance_
absorbances1752944absorbances
absorptances1861674absorptances
accordances1553194accordances
discordances1853684discordances
emittances1443824em_ittances
esperances1446254esper_ances
expectances2493344expectances
ignorance1244584ignor_ance_
imbalances1643674im_balances
immittance1652634immittance_
immortalise15114464immortalise
immortalises1693934immortalises
immortalizes2593914immortalizes
immortals1343804immorta__ls
immortelles1551864immortelles
impatiences1753704impatiences
impedance1644964imp_edance_
impenitences1854024impenitences
imperatives1846444imperatives
impermanences2162474impermanences
impertinences1953594impertinences
impetrates1445454impetra_tes
impones112712254impo___n_es
importation15147124importation
importations16156144importations
imported13308694import___ed
importer12308914import___er
importers13247764import__ers
importing1438194importin__g
imports11309624import____s
importunate1553104importunate
importunely1852454importunely
importuning1652524importuning
importunities1762724importunities
importunity1852444importunity
imposthumes2051014imposthumes
impostumes1652694impost_umes
impostures1443804impost_ures
impotency1844484impo_tenc_y
impotents1347004impo_ten_ts
imprudences1853294imprudences
impudences1744444imp_udences
impuissances1871654impuissances
inductances1663514inductances
inheritances1753924inheritances
instances1148754i__nstances
insurances1246864insur_ances
invariances1653884invariances
isooctanes1253114isooctan_es
iterances1148914i_ter_ances
militances1445684_militances
montanes101114524_m_ontan_es
mordancies1544704_m_ordancies
mortices12711564_m_ort_ices
parlances1348954__parlances
pittances1345704__pittances
portables1337874__portables
portages112613224__porta_ges
potences12710694__po_tences
prances113618774__p_r_ances
repentances1556114repentances
reportages1344384reporta_ges
reprobances1754134reprobances
temperances1754734temper_ances

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 Limit148819848.35617809.8
3Display Results84840.0461826.1
 (SQL Overall)178691848.82520248.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.