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

164 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
hemps12691733(None) 
heaps105223221heaps
helps105219341helps
hemes105031081hemes
hemp115725621hemp_
hempy154912761hempy
hems95534941hem_s
humps126322801humps
kemps135012521kemps
temps95417131temps
amps86230342_amps
beeps95320972beeps
bemas96424282bemas
bumps115921142bumps
camps116330262camps
ceps86125952ce_ps
champs154915682champs
cheaps134613682cheaps
cheeps135312912cheeps
chemos13311722chemos
chimps155713662chimps
chomps155112222chomps
chumps154313822chumps
comps115526052comps
damps105220412damps
deeps84921772deeps
demes86032692demes
demos86022992demos
dumps105220102dumps
emes65434662_emes
ems56435492_em_s
emus66821682_emus
femes105626222femes
fems96428702fem_s
gamps105323712gamps
gems75329112gem_s
gimps105915202gimps
haems105517012haem_s
hames106138702hames
hams96446132ham_s
haps96443462h_aps
harps105926872harps
hasps105114642hasps
heads95127112heads
heals85733452heals
heap96432892heap_
heapy135914982heapy
hears86737372hears
heats85838402heats
hebes105521672hebes
hecks145220652hecks
heeds95420422heeds
heels85625532heels
hefts116218152hefts
hehs106723962he_hs
heils85222192heils
heirs85618562heirs
hells85032042hells
helms105619462helms
helos84928062helos
help95328922help_
hem86148732hem__
hemal104419802hemal
heme95034412hem_e
hemic125718622hemic
hemin103620932hemin
hemins113417562hemins
hempen1338962hempen
hempie132410562hempie
hens75642572he_ns
hents87330742hents
hep86644142he_p_
herbs105520502herbs
herds96424682herds
heres86245902heres
herls85226432herls
herms105626432herms
herns84825582herns
heros84930862heros
herpes115517322herpes
hers75844872he_rs
hes66654202he__s
hests85829932hests
heths116317782heths
hets75547202he_ts
hews105631572he_ws
hexes155123042hexes
hims95230972him_s
hips96433702h_ips
homes106938812homes
homos105921782homos
hoops105621072hoops
hops97942632h_ops
hump116228722hump_
humph155712212humph
humphs16528162humphs
humpy155115672humpy
hums96831422hum_s
humus106215072humus
hymns1337522hymns
hyps125418412h_yps
imps86221122_imps
jeeps144715372jeeps
jumps165116492jumps
keeps116020282keeps
kelps115116422kelps
kemp126418762kemp_
kempt134318462kempt
keps106027302ke_ps
lamps95624832lamps
leaps75522932leaps
limps95522672limps
lumps95624982lumps
memes94927702memes
memos95719112memos
mems85931502mem_s
mumps115619102mumps
neaps75618322neaps
neeps75617882neeps
nemas75321572nemas
peeps95822362peeps
peps85134512pe_ps
perps95521482perps
pimps114616982pimps
pomps115316192pomps
pumps115520602pumps
ramps96224632ramps
reaps75626192reaps
remaps105012872remaps
rems66237722rem_s
repps95114342repps
reps65937952re_ps
rhemes115913182rhemes
romps94617542romps
rumps95922292rumps
samps96124672samps
seeps74828752seeps
semes75731582semes
semis74623532semis
simps94719762simps
sumps95023432sumps
tamps95524082tamps
temp85323332temp_
tempi94912202tempi
tempo95214972tempo
tempos103812292tempos
tempt95124842tempt
tempts10439452tempts
themes115319252themes
thesps11448262thesps
thumps13449352thumps
tumps95420792tumps
umps85721942_umps
vamps125415482vamps
veeps104715722veeps
weeps104120562weeps
wheeps14439952wheeps
whelps14437842whelps
whomps16457602whomps
whumps16427092whumps
wimps125213802wimps
yelps105712992yelps
yeps95924402ye_ps
zeps156019342ze_ps

Search took 2 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 Filter178691538000.313570897.8
2DLD Change Limit538001641.39038705.0
3Display Results1641640.0463565.2
 (SQL Overall)1786911641.749102167.5
 
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.