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

165 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
imported1330869(None) 
imparted13248061imparted
importer12308911importer
imposted13257401imposted
comported16319532comported
deported1249702deported
disported13310302disported
exported1837132exported
impacted15286352impacted
imparked17264862imparked
imparter12357542imparter
impasted13297552impasted
implored13135372implor_ed
imponed12279452impo_ned
import102713762import__
importers13247762importers
imports11309622import_s
importuned1542892importuned
imposed123110292impo_sed
imposter12288162imposter
improved1644772improved
imputed1236532imp_uted
intorted9310122intorted
ported94223242__ported
reimported1543782reimported
reported11312702reported
sported104015432_sported
aborted10310423_aborted
assorted956603assorted
biparted1335133biparted
cavorted1435693cavorted
comforted17315963comforted
comparted16338423comparted
composted16378813composted
dehorted1357303dehorted
departed1238823departed
deportee11510353deportee
deporter1169393deporter
disparted1338853disparted
distorted1139373distorted
emoted94614923em_o_ted
escorted1136703escorted
exhorted1935013exhorted
experted1838053experted
exporter1737363exporter
extorted1636233extorted
homeported1853513homeported
ignored9226443ignor_ed
imbarked17254063imbarked
imbodied1444203imbodied
imbrued1234693im_brued
imbruted1343693imbruted
imitated1138263imitated
immerged1444023immerged
immersed1344833immersed
immolated1444873immolated
immortal1244103immortal
immured1235063immur_ed
impacter14296573impacter
impainted1454773impainted
impaired1335143impaired
impaled12288513imp_aled
impart102715143impart__
imparters13276573imparters
imparts11298533impart_s
impaste11258003impaste_
impastes12238193impastes
impastoed14242803impastoed
impawned1643443impawned
impearled1442863impearled
imped105117983imp___ed
impeded13418183imp_eded
impelled1336073impelled
impended1435953impended
imperiled1445493imperiled
impetrated1544363impetrated
impinged14275123impinged
implanted1475493implanted
impled113812513imp__led
implied1238623imp_lied
imploded14145073imploded
implore11176703implor_e_
implorer12125103implor_er
implores12127043implor_es
impolite1249293impolite_
impone103011863impo_ne_
impones112712253impo_nes
imporous1246303imporous
important1346723important
importing1438193importing
importune1344773importune
importuner1452683importuner
importunes1444473importunes
impose103113053impo_se_
imposer113310103impo_ser
imposes113213683impo_ses
impost103011783impost__
imposters13347343imposters
impostor12265483impostor
imposts11269003impost_s
impotent1249533impo_tent
impound1235393impo_und
impounded1543603impounded
impower14247123impo_wer
impowered1743143impowered
imprinted1445753imprinted
improper1444533improper
improve1435963improve_
improver1545243improver
improves1536123improves
impugned14333923impugned
impulsed1334003impulsed
impure1038383impur_e_
impurer1136483impur_er
impute1038043imp_ute_
imputer1136533imp_uter
imputes1138083imp_utes
indorsed1066123indorsed
informed14197673informed
ingoted939183ingo_ted
inpoured1135813inpoured
inputted1134663inputted
inserted92413053inserted
inverted122312163inverted
marted94425213_m_arted
minored10310103minor_ed
misparted1437263misparted
missorted1247033missorted
moated94819003_m_oated
molted94217473_m_olted
moored93814173_moor_ed
mooted94120373_m_ooted
parted94228683__parted
pored85234513__por_ed
porked134717623__porked
portend103411193__portend
porter84224413__porter
posted93722493__posted
potted94624013__potted
pouted94021393__pouted
purported1443463purported
ramparted1443543ramparted
reporter10411423reporter
repotted1139283repotted
resorted9313493resorted
retorted9312333retorted
riposted11216933riposted
shorted113614403_shorted
simpered1338253simper_ed
smarted105012613sm_arted
snorted83813493_snorted
sorted74523713__sorted
spirted103913073_spirted
spored94821793_spor_ed
sporter93616553_sporter
spotted103713143_spotted
spouted103412263_spouted
spurted103111973_spurted
supported1444683supported
umpired1235783umpir_ed
unparted11310823unparted
unposted1159433unposted
unpotted11108393unpotted
unsorted9312513unsorted
vapored1336923vapor_ed

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621656.26623326.2
3Display Results1651650.0762171.1
 (SQL Overall)1786911656.76226425.8
 
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.