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

134 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
hippish173618(None) 
foppish1735102foppish
hickish1936472hickish
hippest14219762hippest
hippie132811242hippi_e
hippieish1941842hippieish
hippier143212102hippier
hippies142813752hippies
hippiest152611622hippiest
hipping153915102hipping
hippos13408432hippos_
impish13499192_impish
quippish2442632quippish
uppish1336632_uppish
wimpish1765692wimpish
wispish1575642wispish
apish105116643__apish
aspish114810333_aspish
biggish14247503biggish
blimpish1743723blimpish
cheapish1844333cheapish
childish1744393childish
chippie16297693chippi_e
chippier17297673chippier
chippies17309763chippies
chippiest18256813chippiest
chipping18389793chipping
dampish1567663dampish
dippier123111393dippier
dippiest132511143dippiest
dipping134014833dipping
dumpish15116113dumpish
finfish16268193finfish
finish124613423fi_nish
gipping133813123gipping
girlish1137193girlish
hagfish17227613hagfish
haggish15207473haggish
haimish1537753haimish
happier143312043happier
happiest152411683happiest
happily1745763happily
happing153817233happing
harpist12312363harpist
hashish1238353hashish
hawkish2036553hawkish
heimish1535463heimish
hellish13310723hellish
hennish1336863hennish
heppest14228153heppest
hipless12399923hipless
hiplike1637603hiplike
hipline12311423hipline
hipness12277383hipness
hipparch2042833hipparch
hipped144317693hipp_ed
hipper133818023hipp_er
hippiness1635463hippiness
hippo12369063hipp__o
hippy155112793hipp__y
hips96433713hi_p_s_
hispid1238173hispi_d
hogfish17257023hogfish
hoggish15247593hoggish
hoppier143110703hoppier
hoppiest152610733hoppiest
hopping154115273hopping
hottish13117903hottish
huffish1935713huffish
hunnish1336163hunnish
huppah1644183hupp_ah
huppahs1743333huppahs
impis96213853_impis_
jiggish19225943jiggish
kiddish16276583kiddish
kipping163311873kipping
lippier112710573lippier
lippiest122310623lippiest
lipping123016073lipping
lumpish14127383lumpish
minish115216313mi_nish
minxish1936213minxish
mopish134311593_mopish
nippier11319833nippier
nippiest12279983nippiest
nippily1444713nippily
nipping123412873nipping
pigfish16217173pigfish
piggish14227703piggish
pinfish15319303pinfish
pinkish16279113pinkish
pipefish1844533pipefish
pippin92810303pippi_n
pipping113414743pipping
pippins10319753pippins
pish96127923___pish
pixyish2253653pixyish
popish133812113_popish
pupfish1735533pupfish
puppyish1742453puppyish
raspish1298103raspish
ripping123315743ripping
rompish1436693rompish
sheepish1645413sheepish
shipping163611253shipping
sickish1638423sickish
sipping123117433sipping
snappish1545243snappish
thickish2044603thickish
thievish1743263thievish
thinnish1454883thinnish
tigrish1137573tigrish
tipis76019923ti_pis_
tippier113210543tippier
tippiest122310023tippiest
tipping122814973tipping
vampish1766293vampish
viperish1655893viperish
wampish1777293wampish
waspish1586923waspish
whiplash1942833whiplash
whippier18265823whippier
whippiest19265123whippiest
whipping19328173whipping
whitish1635973whi_tish
widish13419363wi_dish
wildish1446853wildish
winish124212273wi_nish
yippie13277843yippi_e
yippies14279293yippies
yipping152710683yipping
zippier20308193zippier
zippiest21248103zippiest
zipping212910573zipping

Search took 8 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.420425454.8
2DLD Change Limit1340271347.08018930.4
3Display Results1341340.0462913.0
 (SQL Overall)1786911347.54623680.2
 
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.