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

253 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
impish1349919(None) 
impis96213851impis_
wimpish1765691wimpish
apish105116632_apish
aspish114810332aspish
blimpish1743722blimpish
dampish1567662dampish
dumpish15116112dumpish
hippish1736182hippish
immesh1334112immesh
impi85415792impi__
imping114315352imping
impishly1844092impishly
impose103113052impose
impost103011782impost
imps86221122imp_s_
lumpish14127382lumpish
minish115216302minish
mopish134311592mopish
pish96127912__pish
popish133812112popish
rompish1436692rompish
uppish1336632uppish
vampish1766282vampish
wampish1777292wampish
wispish1575642wispish
aguish1059283aguish
ambush1336113ambush
amis66445323am_is_
amiss75823073am_iss
amping114317573amping
amps86230343amp_s_
aspis74618143aspis_
banish111416043banish
biggish14247503biggish
bluish1159243bluish
boyish142911233boyish
clumpish17164893clumpish
coyish143710393coyish
cuish10313173_cuish
danish101513793danish
delish105215613delish
diminish14127523diminish
dish86328333__dish
dovish1338103dovish
dryish1336323dryish
dudish1148313dudish
elfish1267963elfish
elvish1277563elvish
emdash12244113emdash
empire1039323empire
emprise11310723emprise
famish14311843famish
fetish12310373fetish
finfish16268193finfish
finish124613413finish
fish106926273__fish
fluish1239333fluish
foppish1735103foppish
frumpish1843503frumpish
garish104516923garish
gimpier12247943gimpier
gimpiest1338483gimpiest
gimping133710763gimping
gimps105915203gimp_s_
girlish1137193girlish
goyish13379013goyish
grumpish1643763grumpish
haimish1537753haim_ish
heimish1535463heim_ish
hickish1936473hickish
ibis66519583i_bis_
imagism1285083imagism
imagist1077333imagist
imams91511113imams_
imbibe1234703imbibe
imid76122293im_i_d
imide85716893im_ide
imido85812243im_ido
imids86015143im_ids
imine75821063im_ine
imino74315233im_ino
immies102412443immies
immix1635033immi_x
imp76626973imp___
impact122310453impact
impaint11511223impaint
impair1036003impair
impairs1135823impairs
impala10256933impala
impale102811663impale
impark14287073impark
impart102715143impart
impasse11246463impasse
impaste11258003impaste
impasto11275193impasto
impawn1333263impawn
impeach1644273impeach
imped105117983imp_ed
impede11469623impede
impel95711773imp_el
impels10389523impels
impend11478793impend
imphee13310353imphee
impiety1445093impiety
impinge12427503impinge
impings12348553impings
impious1137063impious
impled113812513impled
implied1238623implied
implies11312123implies
imply124911843imp_ly
impone103011863impone
import102713763import
imposed123110293imposed
imposer113310103imposer
imposes113213683imposes
imposts11269003imposts
impresa1134753impresa
imprese1138143imprese
impress1137773impress
imprest11310203imprest
imprint11312563imprint
imprison1244793imprison
improv1344643improv
impugn1143163impugn
impulse1135113impulse
impure1038383impure
impute1038043impute
incise83515333incise
inmesh1134863inmesh
inrush936513inrush
insist6314513insist
intis55121643intis_
iodise74214943iodise
iodism93611133iodism
ionise63516943ionise
iris45732553i_ris_
iwis77117013i_wis_
jadish17319903jadish
jiggish19225943jiggish
jimpest18297553jimpest
kepis115313363kepis_
kiddish16276583kiddish
knish1238603_knish
lapis76223153lapis_
latish92416173latish
lavish124112983lavish
limpas105513083limpas_
limpest113712313limpest
limpid11389753limpi_d
limping124614113limping
limps95522673limp_s_
limpsy13516843limp_sy
lowish12310533lowish
lumpfish1843053lumpfish
maist75535683_maist
marish114319053marish
marsh105320853_marsh
mash96039403_m_ash
mensh105413563_mensh
mesh96823003_m_esh
midis85923413midis_
minis75432993minis_
minxish1936213minxish
mips85534083mip_s_
mis58162623_m_is_
mise66043583_m_ise
miso67229903_m_iso
miss65339423_m_iss
mist66154533_m_ist
mitis75425993mitis_
modish123813543modish
moist76033583_moist
monish114217593monish
mosh95227603_m_osh
mulish11311903mulish
mush94929123_m_ush
newish1237903newish
oafish121311723oafish
oddish11107653oddish
offish15137273offish
ogrish1039263ogrish
oldish10169313oldish
owlish1238703owlish
palish114718273palish
papism122211513papism
papist102618753papist
parish115022353parish
pash95638133__pash
perish114619063perish
pigfish16217173pigfish
piggish14227703piggish
pimping143812123pimping
pimps114616983pimp_s_
pinfish15319303pinfish
pinkish16279113pinkish
pis56362033__pis_
piso66727563__piso
piss65033333__piss
pith95432693__pith
pixyish2253653pixyish
plumpish17164733plumpish
polish114916723polish
posh95427323__posh
punish111411503punish
pupfish1735533pupfish
push95526623__push
quippish2442633quippish
radish103516913radish
rakish134313963rakish
rammish1437563rammish
rapist82520673rapist
raspish1298103raspish
ravish123414033ravish
rawish123012913rawish
relish93916953relish
rupiah1146213rupiah
scampish1744893scampish
sickish1638423sickish
simplism14216243simplism
simplist12249683simplist
simps94719763simp_s_
smash104814433sm_ash
smith107818053sm_ith
smoosh11236733smoosh
smush104410583sm_ush
squish1838573squish
swampish1844173swampish
swish115114823_swish
tapis75028863tapis_
tigrish1137573tigrish
tipis76019923tipis_
tonish93415903tonish
topis76025833topis_
toyish122911123toyish
trampish1535653trampish
typist1139823typist
umping114815333umping
umpire1047893umpire
umps85721943ump_s_
unwish1239093unwish
vanish121513213vanish
waspish1586923waspish
whish144512923_whish
widish13419363widish
wildish1446853wildish
wimpier14248053wimpier
wimpiest1538763wimpiest
wimping153911013wimping
wimps125213803wimp_s_
winish124212263winish
wish107228733__wish

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 Filter1786911127160.393454684.5
2DLD Change Limit1127162536.09318499.3
3Display Results2532530.0763328.9
 (SQL Overall)1786912536.56227231.2
 
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.