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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

114 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
impresa113475(None) 
impresas1244451impresas
imprese1138141imprese
impress1137771impress
imprest11310201imprest
empress1138162empress
imperia1148422imperia
impregn1243402impregn
impreses1238092impreses
imprests1246312imprests
impurest1245912impurest
presa74319042__presa
amperes11313983amperes_
amplest11312333amplest
apres75426403_apres_
compress1439053compress
cypres1338523cypres_
cypress1434653cypress
depress10239873depress
dimples122813213dimples_
empires1139853empires_
emprise11310723emprise
empyema1642643empyema
express1637493express
gimpiest1338483gimpiest
images91411463images_
imaret81121233imare_t
imarets9138643imarets
imbrues1135503imbrues_
imbues1037983imbues_
imides94515343imides_
imines84918353imines_
immerse1145793immerse
immesh1334113im_mesh
immies102412443immies_
immures1136713immures_
impala10256933imp_ala
impalas11236953impalas
impales113311763impales_
imparks15276663imparks_
imparts11298533imparts_
impasse11246463impasse
imped105117983imp_e_d
impede11469623imp_ede
impedes124310093impedes_
impel95711773imp_e_l
impels10389523imp_els
impend11478793imp_end
imperial1249023imperial
imperil1147683imperil
imphee13310353imphe_e
imphees1436693imphees
impiety1445093impiety
impis96213853imp_is_
impish13499193imp_ish
implead12315823implead
impled113812513imple_d
implies11312123implies_
implores12127043implores_
impones112712253impones_
imports11309623imports_
impose103113053imp_ose
imposed123110293imposed
imposer113310103imposer
imposes113213683imposes
impost103011783imp_ost
imprecate1545533imprecate
imprecise1545193imprecise
impregns1343643impregns
impresario1452243impresario
impressed1446283impressed
impresses1338213impresses
imprint11312563imprint
imprison1244793imprison
improv1344643impr_ov
improve1435963improve
improves1536123improves_
improvs1435003improvs
imps86221123imp__s_
impulse1135113impulse
impure1038383impure__
impurely1544033impurely
impurer1136483impure_r
imputes1138083imputes_
ingress838653ingress
inures63318953inures_
ires45639283i__res_
jimpest18297553jimp_est
limpers113815223limpers_
limpest113712313limp_est
limpness1246703limpness
mares76457633_mares_
meres75143573_meres_
merest84725113_merest
mesa67025483_m__esa
mires75640883_mires_
mitres83922073mitres_
mores76249643_mores_
mures75937223_mures_
ombres103911143ombres_
oppress1135993oppress
pimples133012423pimples_
prese75228383__prese
press75425953__press
prest75736353__prest
repress92712683repress
rimples113114223rimples_
simpers113014123simpers_
simples113014943simples_
simplest122310223simplest
timbres11249353timbres_
umpires1137813umpires_
wimpiest1538763wimpiest
wimples143311173wimples_

Search took 7 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 Filter1786911340270.406440125.6
2DLD Change Limit1340271146.28321331.7
3Display Results1141140.0432651.2
 (SQL Overall)1786911146.73226543.5
 
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.