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

122 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
whore11601804(None) 
chore105126761chore
shore85432651shore
where117019421where
whole114418091whole
whored135512121whored
whores125617101whores
whorl114612451whorl
whort114623691whort
whose114914531whose
wore77144671w_ore
adore65723672adore
afore85818602afore
ahorse9311512ahorse
ashore9414612ashore
bore66051332_bore
chare105231982chare
choke145118022choke
chord115917262chord
chorea115216092chorea
chored125321882chored
chores114828022chores
chose105925402chose
core67263112_core
crore74922872crore
dhole95215362dhole
dore56353302_dore
fore78351472_fore
frore86218802frore
gore55744962_gore
hare76255732_hare
here76447102_here
hire75538962_hire
hoe67562722_ho_e
hoer76533982_hoer
hoke115935932_hoke
hole77553392_hole
home98042442_home
hone77549322_hone
hope96639672_hope
hora76136562_hora
horde94623052_horde
horn76735612_horn
horse86132652_horse
hose76547242_hose
hove107132222_hove
howe106734102_howe
kore85834162_kore
lore45850352_lore
more67154522_more
ore36661832__ore
phone105621932phone
pore66451262_pore
score75526742score
share86437082share
shire84727132shire
shoe75933442sho_e
shoer84722162shoer
shone83725982shone
shored105723652shored
shores94830412shores
shorl84720252shorl
shorn85722182shorn
short85040532short
shote85526102shote
shove114421042shove
snore55424952snore
sore47059532_sore
spore75428592spore
store56333812store
swore84920822swore
there87527392there
thole85620842thole
thorn85318702thorn
thoro86217872thoro
thorp104414262thorp
thorpe113610092thorpe
those85218142those
throe89321422throe
tore47359322_tore
ware76254722w_are
were76238332w_ere
whale115517432whale
wharf14315822wharf
wharve15456202wharve
whee105429592wh_ee
wheres125917432wheres
wherve15568112wherve
while115418692while
whine116022812whine
whir105519282whir_
whirl114913822whirl
whirr114611192whirr
whirs115218092whirs
white114920302white
who95526772who__
whoa106615202who_a
wholes124616772wholes
whom127018182who_m
whomp155011322whomp
whoof144612692whoof
whoop134211442whoop
whop125520922who_p
whops135013932whops
whorled14366902whorled
whorls124410162whorls
whortle13335942whortle
whorts125111432whorts
whoso11509222whoso
wire75839812w_ire
woe66651242w_o_e
woke115527962w_oke
wooer84316692wooer
word89832002w_ord
work115528842w_ork
worm96129492w_orm
worn75631752w_orn
worse86525262w_orse
wort76654752w_ort
wove105624312w_ove
wrote84717482wrote
yore76335942_yore

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.470380193.6
2DLD Change Limit538001221.45337026.8
3Display Results1221220.0304066.7
 (SQL Overall)1786911221.95391495.6
 
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.