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 “hype” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

144 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
hype12551981(None) 
hope96639671hope
hyp117822461hyp_
hyped145313331hyped
hyper135213901hyper
hypes135818671hypes
hypo127516351hypo
hyps125418411hyps
hyte109018941hyte
type96223741type
ape57251182_ape
aye67151762ay_e
blype12429672blype
bye86134592by_e
byre95023852byre
byte96521812byte
cape87242782cape
cepe84926652cepe
chape125221142chape
chyle134913482chyle
chyme156512502chyme
cope86847382cope
cyme119420372cyme
dope76038892dope
dupe76630602dupe
dye75334842dy_e
dyke126418182dyke
dyne85320932dyne
eye65539772ey_e
eyne76322462eyne
eyre75525252eyre
fyce126316832fyce
fyke145915292fyke
gape75134512gape
gybe105916242gybe
gyp98319012gyp_
gyps105115022gyps
gyre84722762gyre
gyve116215082gyve
hade85440192hade
hae67364002h_ae
hake115637842hake
hale76052832hale
hame97043132hame
hap87360052hap_
haps96443462haps
hare76255732hare
hate78450172hate
have106137072have
haze164833392haze
he58151952h__e
hebe96424702hebe
heme95034412heme
hep86644142hep_
here76447102here
hide85134632hide
hie67652702h_ie
hike116830392hike
hip86750432hip_
hips96433702hips
hire75538962hire
hive106029672hive
hoe67562722h_oe
hoke115935932hoke
hole77553392hole
home98042442home
hone77549322hone
hop87554592hop_
hoped115628182hoped
hoper105829142hoper
hopes105835642hopes
hops97942632hops
hose76547242hose
hove107132222hove
howe106734102howe
hoyle11314412hoyle
hue66642302h_ue
huge86321652huge
hup86437812hup_
hyla106716512hyla
hymen13311042hymen
hymn12311312hymn
hypers144811912hypers
hypha1637382hypha
hyphae1746432hyphae
hyphen1736392hyphen
hypoed1547922hypoed
hypos1312014742hypos
jape134923422jape
jupe134921002jupe
kye107327272ky_e
kyte117017762kyte
lipe66839732lipe
lope65941922lope
lye66533412ly_e
lyre75623792lyre
lyse76320592lyse
mope86838042mope
myope124010972myope
nape65230802nape
nope65934192nope
ope56845242_ope
pe47649032__pe
phyle134111152phyle
pipe86434432pipe
pope85535612pope
pye86432502py_e
pyre94925552pyre
rape65041632rape
rhyme13479552rhyme
ripe66038922ripe
rope65542912rope
rye66032542ry_e
ryke115616402ryke
shape105125112shape
sipe67341042sipe
slype105112362slype
supe65932762supe
syce95820282syce
syke115420562syke
syne75725762syne
syph125413272syph
tape64538142tape
thyme134612472thyme
tope65946382tope
tye65837442ty_e
tyee75131422tyee
tyke115720502tyke
tyne76325052tyne
typed115815452typed
types105721062types
typey135511882typey
typo95418122typo
typp115812782typp
typy126013042typy
tyre75428252tyre
wipe94830282wipe
wye96331972wy_e
wyle105519382wyle
wyte106018642wyte
ye57650062_y_e
yep86638962_yep
yipe96722182yipe
zyme1819114942zyme

Search took 1 second 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 Filter178691298720.0602978183.3
2DLD Change Limit298721440.81336742.9
3Display Results1441440.0334363.6
 (SQL Overall)1786911440.906197230.7
 
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.