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

137 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
impious113706(None) 
copious11311962copious
imperious1346582imperious
impetus1144892impetus
impings12348552impings
impiously1645822impiously
impis96213852impi__s
imporous1246302imporous
improvs1435002improvs
nimious937662nim_ious
pious74621272__pious
simious939802sim_ious
adipous1037183adipous
amadous1038503amadous
amicus103810003am_icus
amnions93710913amnions
amnios84912523amnio_s
amorous9311133amorous
amphioxus2352213amphioxus
anxious1437283anxious
bilious9310933bilious
bimanous1245693bimanous
bumptious1543143bumptious
campions143511293campions
captious122810573captious
carious93320283carious
cuprous1149743cuprous
curious93813563curious
devious1138523devious
diecious1146873diecious
dimerous1139323dimerous
dubious1036893dubious
empires1139853empires
employs1455523employs
emulous937343emulous
envious1037223envious
eximious1743873exim_ious
folious103710733folious
furious103110633furious
gumptious1443053gumptious
idioms956413i_dioms
idiots768643i_diots
igneous835773igneous
imagoes10126403imagoes
imagos9117553imago_s
imbibes1334693imbibes
imides94515343im_ides
imids86015153im_i_ds
imines84918353im_ines
immies102412443immi_es
immixes1835073immixes
impacts13266503impacts
impaints1236243impaints
impairs1135823impairs
impalas11236953impalas
impales113311763impales
imparks15276663imparks
imparts11298533imparts
impawns1433323impawns
impedes124310093impedes
impels10389523imp_els
impends12376803impends
impervious1752963impervious
impetuous1342933impetuous
imphees1436693imphees
impi85415793impi___
impiety1445093impiety
imping114315353impi_ng
impinge12427503impinge
impinges13297423impinges
impish13499193impi_sh
implies11312123implies
implode12156103implode
implodes13106393implodes
implore11176703implore
implores12127043implores
impone103011863imp_one
impones112712253impones
import102713763imp_ort
imports11309623imports
impose103113053imp_ose
imposes113213683imposes
impost103011783imp_ost
imposts11269003imposts
impound1235393imp_ound
impounds1344123imp_ounds
impress1137773impress
imprimis1444253imprimis
imprints1247303imprints
imprisons1344913imprisons
improv1344643impro_v
improve1435963improve
improves1536123improves
imps86221123imp___s
impugns1243333impugns
imputes1138083imputes
inions64417003i_nions
inpour837063inp_our
inpours936423inp_ours
iodous7311503i_odous
lampions12277973lampions
leprous938843leprous
lupous849433lup_ous
meous76120063_m_eous
miaous8511693_miaous
milieus939803milieus
minibus1136343minibus
minions93314623minions
minus75223933_m_inus
mucous104411653_mucous
noxious1446563noxious
obvious1244823obvious
odious749933_odious
ominous949033ominous
omnibus1152983omnibus
osmious936003osmious
pappous1057463pappous
pilous84717753__pilous
pilus75921063__pilus
pions75826393__pions
pompous1338063pomp_ous
rampions12248023rampions
rimous8311913rim__ous
rubious938283rubious
sanious7514103sanious
semipious1385523semipious
serious73616283serious
spinous9310443_spinous
tampions12358123tampions
tedious838443tedious
timeous938403tim_eous
timorous1047433timorous
tompions12267003tompions
typhous1566323typhous
umpires1137813umpires
various103113103various
vicious1239493vicious

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 Filter1786911340270.563317390.8
2DLD Change Limit1340271379.22014536.6
3Display Results1371370.0462978.3
 (SQL Overall)1786911379.82918180.0
 
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.