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

145 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
whop12552092(None) 
chop116024921chop
hop87554591_hop
shop95629841shop
whap125119641whap
whip125521841whip
who95526771who_
whoa106615201whoa
whom127018181whom
whomp155011321whomp
whoop134211441whoop
whops135013931whops
whup125714161whup
wop87145131w_op
ahoy101919182ahoy
atop66124752atop
bop77549482_bop
chap114928492chap
chip116726422chip
chomp144815662chomp
chon96627792chon
chops125019872chops
chow125820992chow
clop86929892clop
coop87238652coop
cop711162372_cop
crop87628632crop
dhow116614002dhow
drop75324402drop
flop96925452flop
fop86743702_fop
glop76724632glop
goop75829482goop
hap87360052_hap
hep86644142_hep
hip86750432_hip
ho510258272_ho_
hob87550922_hob
hod76852462_hod
hoe67562722_hoe
hog78049062_hog
holp95727552_holp
hon67759382_hon
hoop96129982hoop
hope96639672_hope
hops97942632_hops
hos68364192_hos
hot67776062_hot
how97252432_how
hoy97447912_hoy
hup86437812_hup
hyp117822462_hyp
knop107116592knop
kop97440202_kop
loop67835012loop
lop58255312_lop
mho86624622mho_
mhos95517772mhos
mop76950822_mop
oho66534382oho_
op45850162__op
phon95925382phon
phot95534362phot
plop86625742plop
poop86532812poop
pop76252252_pop
prop85932812prop
rho65924832rho_
rhos76319062rhos
scop85925522scop
ship95228242ship
shod86225062shod
shoe75933442shoe
shog86025142shog
shoo75929892shoo
shops104222902shops
shot76150262shot
show106229192show
slop66533872slop
sop57557862_sop
stop66532032stop
swoop105213432swoop
swop95120502swop
tho67433962tho_
thorp104414262thorp
thou76722212thou
top510560682_top
trop66833302trop
wahoo112413082wahoo
wap86553372w_ap
warp95635002warp
wasp95626852wasp
weep95131652weep
wha96422072wh_a
wham125321692wham
whaps135115162whaps
what105434072what
whaup13458882whaup
whee105429592whee
wheep136214352wheep
whelp136012092whelp
when105723042when
whet105133782whet
whew137618782whew
whey135018712whey
whid115418872whid
whig115516422whig
whim126220532whim
whin105225692whin
whips134917082whips
whipt135317422whipt
whir105519282whir
whit104834172whit
whiz195919942whiz
whole114418092whole
whomps16457602whomps
whoof144612692whoof
whoops14487862whoops
whore116018042whore
whorl114612452whorl
whort114623692whort
whose114914532whose
whoso11509222whoso
whump154910042whump
whups134210002whups
why126920012wh_y
whys137011662whys
wimp115521522wimp
wisp97124072wisp
wo510447762w_o_
woe66651242w_oe
wog76242732w_og
wok106334172w_ok
won66252062w_on
woo66949802w_oo
wood85329382wood
woof106532422woof
wool76427372wool
woops104917522woops
woos76238802woos
wops96634152w_ops
wos66953532w_os
wot610467482w_ot
wow96643472w_ow
wrap96821972wrap

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.1101624463.6
2DLD Change Limit298721450.82636164.6
3Display Results1451450.0304833.3
 (SQL Overall)1786911450.966184980.3
 
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.