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

277 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
hispid123817(None) 
cuspid11429212cuspid
hasped125014442hasped
hipped144317692hipped
hippie132811242hippie
hissed104114452hissed
histed104420242histed
histoid1139822histoid
limpid11389752limpid
lipid85916172li_pid
lisped94113422lisped
misdid10510572misdid
vespid1246082vespid
viscid1237472viscid
wisped123411892wisped
aisled74516183aisled
aspic95114733_aspic
aspis74618143_aspis
bhistie1236773bhistie
bicuspid1542463bicuspid
bifid11910703bi_fid
biopic123710673biopic
biped104718833bi_ped
bipod104410823bi_pod
capsid11312423capsid
chipped174110813chipped
chippie16297693chippie
chirped15379783chirped
cirsoid1038123cirsoid
cissoid1037343cissoid
cisted95217523cisted
cosmid11810643cosmid
crisped124010113crisped
cupid103212783_cupid
cusped114312043cusped
cuspids12427113cuspids
cuspis105010703cuspis
desmid1048363desmid
diacid10310633diacid
diapir9357113diapir
diapsid1146703diapsid
dioxid1568393dioxid
dipped123517493dipped
disbud10165713disbud
disced104914653disced
disci85815023disci_
discoid11311243discoid
dished114318713dished
disked125015763disked
dispel9310323dispel
dispend11289413dispend
dissed85220183dissed
distil73616433distil
elapid939543elapid
espied9359783_espied
fished134316313fished
fisted104218703fisted
fistic11812573fistic
gasped104814293gasped
gimped123911473gimped
gipped124815903gipped
gipsied1135883gipsied
hairpin1245413hairpin
halid94424983h_alid
haloid104317763haloid
happed144820103happed
harped124418403harped
harpin113614383harpin
hashed136021943hashed
hasp96627293hasp__
hasping134414903hasping
hasps105114643hasp_s
hasted105125283hasted
hatpin112610613hatpin
heaped124516903heaped
heishi1235843heishi_
heisted113210653heisted
helped124714153helped
hemoid12313513hemoid
hempie132410563hempie
hickie153812473hickie
hid76248383h___id
hided105222443hi_ded
hied85434043hi__ed
hiked135919203hi_ked
hili75626633hi_li_
hilled104022223hilled
hilted104016043hilted
hind85529753hi__nd
hinged114618923hinged
hinnied11348113hinnied
hinted104318323hinted
hip86750433hi_p__
hiply134113613hi_ply
hipper133818023hipper
hippier143212103hippier
hippies142813753hippies
hipping153915103hipping
hippish1736183hippish
hippo12369063hi_ppo
hippos13408433hippos
hippy155112793hi_ppy
hips96433703hi_p_s
hired95226263hi_red
hirple11158973hirple
hirpled13157143hirpled
hirsled11118113hirsled
his66359503his___
hisn79620933his__n
hispidity1843403hispidity
hiss75629213his__s
hisser94713793hisser
hisses94719353hisses
hissier103410503hissier
hissies103915823hissies
hissing114213143hissing
hissy116112123his_sy
hist76551543his__t
histidin1244933histidin
histing113720373histing
hists86328373his_ts
hived125217913hi_ved
hoised105117433hois_ed
hoisted113411293hoisted
hooped125518183hooped
hoped115628183h_oped
hopped144318113hopped
horrid10311563horrid
hosed95830983hos_ed
hospice14117063hospice
hosted105020343hosted
huipil1143773huipil
humid114213763h_umid
humped144015243humped
hushed134416673hushed
husked144212223husked
hybrid15237813hybrid
hydrid14248973hydrid
hyoid12612443h_yoid
hyped145313333h_yped
imid76122293_i_mid
imped105117983_imped
impi85415793_impi_
impis96213853_impis
insipid1044513insipid
iodid74315533_iodid
irid55927173_i_rid
isled64615993_isled
isopod935913_isopod
jassid1467223jassid
kidvid1535023kidvid
kipped153114573kipped
kissed114412853kissed
limped114817123limped
lipide93511063li_pide
lipids94310923li_pids
lipin75518893li_pin
lipoid9411043lipoid
lipped114419543lipped
liquid1637143liquid
lisp68926883lisp__
lisper84114433lisper
lisping103412753lisping
lisps76913913lisp_s
listed74322833listed
livid96714423li_vid
masjid16187323masjid
misadd1037163misadd
misaim10311853misaim
misbind1258273misbind
misfed124113023misfed
misfit112813833misfit
mishit112618203mishit
mislaid1039303mislaid
misled94719313misled
mislie83219153mislie
mislit83019693mislit
mispen10312173mispen
mispled12310463mispled
missaid10310303missaid
missed94423603missed
missis84417503missis
misted93625823misted
muscid11219833muscid
musjid16216953musjid
mysid11610693mys_id
nipped113615853nipped
nisei54214353nisei_
niseis63512023niseis
nisi45823243nis_i_
nitid61817833ni_tid
nitrid72812233nitrid
phasmid15267603phasmid
phosphid1985613phosphid
pimped134913483pimped
piped105123163pi_ped
pipit95224873pi_pit
pipped104516543pipped
pippin92810303pippin
pished124817063pished
pissed94816933pissed
pistil83915073pistil
rapid86422033_rapid
rasped94715203rasped
resaid74517083resaid
resid64124093res_id
rhizoid2044583rhizoid
rigid7913893ri_gid
riped85226433ri_ped
ripped114419013ripped
rishi8311253rishi_
rishis9312453rishis
risked115514633risked
said55742113__said
salpid9510883salpid
sapid84720933_sapid
shilpit1247103shilpit
shipped153312103shipped
shipside1445033shipside
sialid7314943sialid
siped84927683si_ped
sipped113720633sipped
siskin1079783siskin
skid95720933__skid
slid55828983__slid
sped76031493__sped
spic85227433__spic
spied85427713__spied
spik105419713__spik
spin66231303__spin
spit65545083__spit
spiv95917793__spiv
spud75818493__spud
stupid937593stupid
tepid8314313_tepid
tiepin839343tiepin
timid84815733ti_mid
tineid74412023tineid
tipi69924433ti_pi_
tipis76019923ti_pis
tipped114418263tipped
torpid9310913torpid
trepid9310083trepid
unsaid7411833unsaid
ursid6311483urs_id
vapid115614283_vapid
vespids1334613vespids
virid94116043vi_rid
viroid10411523viroid
visaed104110503visaed
visard103910123visard
viscoid1337023viscoid
vised95518763vis_ed
viseed105310983viseed
visit8320963vis_it
vivid125112313vi_vid
whipped18379333whipped
whished17428023whished
whisked18336913whisked
whisper15298013whisper
whisted144010013whisted
wimped144211513wimped
wiped114722083wi_ped
wised95123343wis_ed
wished134417513wished
wisp97124073wisp__
wispier12249403wispier
wispily1535653wispily
wisping133711943wisping
wispish1575643wispish
wisps105214183wisp_s
wispy137210973wisp_y
wissed104114643wissed
wisted104120273wisted
yipped143613283yipped
yippie13277843yippie
zipped203612983zipped

Search took 6 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.376475242.0
2DLD Change Limit1127162775.39020912.1
3Display Results2772770.0932978.5
 (SQL Overall)1786912775.85930498.5
 
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.