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

196 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
gorms8561959(None) 
corms95626221corms
dorms85723841dorms
forms105327051forms
germs85118871germs
gores65740371gores
gorm75529391gorm_
gorps85316991gorps
norms76019311norms
worms105320761worms
agoras7613342agoras
arms66137492_arms
barms96128462barms
berms95323662berms
booms95427122booms
boras75938302boras
bores76448252bores
borks115727702borks
borts76735452borts
cords86030622cords
cores76361852cores
corks116028272corks
corm85735382corm_
corns76034762corns
corps95927042corps
cors66656442cor_s
derms85022892derms
doms76239572do_ms
dooms85321342dooms
dorks105724442dorks
dorm76834632dorm_
dormy115817472dormy
dorps85419222dorps
dorrs65520592dorrs
dors56747602dor_s
doums85417642doums
farms106324952farms
firms105217422firms
foams105017952foams
forams115115912forams
forbs105720802forbs
fords95328182fords
fores85847102fores
forks125324682forks
form95836872form_
forme105225992forme
formes114623712formes
forts86034452forts
forums114611842forums
gams76648882g_ams
garbs86321412garbs
gars55750742gar_s
gaums86217072gaums
gems75329112g_ems
germ75428962germ_
germy115113662germy
geums85414112geums
girds74816992girds
girls64518392girls
girns64516802girns
giros65722652giros
girts65423622girts
glams85822932glams
glims87417672glims
gloams95210662gloams
gloms85219782gloms
glooms96211682glooms
glums84621422glums
goads77022852goads
goals65521292goals
goas55239942go_as
goats65527302goats
gobos86219382gobos
gobs76935572go_bs
gods65438042go_ds
goers65520252goers
goes55644092go_es
gogos77516522gogos
golds75421312golds
golems939322golems
golfs95616102golfs
gongs74921612gongs
goods75124482goods
goofs94821002goofs
gooks105422882gooks
goons65326772goons
goops86620962goops
goos57644912go_os
gor47848262gor__
goral65125752goral
gorals76917652gorals
gore55744962gor_e
gored75227082gored
gorge76423892gorge
gorges85321892gorges
gormed105013832gormed
gorp75625902gor_p
gorse65926812gorse
gorses74723292gorses
gorsy95915782gorsy
gory86129662gor_y
gos47155132go__s
goths96513002goths
gourds8108252gourds
gouts64826172gouts
gowds105814042gowds
gowks136011952gowks
gowns95115102gowns
goxes135018262goxes
goys86328412go_ys
grams85327312grams
grogs76319412grogs
groks105716122groks
grooms94512522grooms
gross65421692gross
grots65025852grots
grows95523922grows
gums75030942g_ums
gurus64318192gurus
gyms107514592g_yms
gyres94820322gyres
gyros95616482gyros
gyrus95310802gyrus
harms106829012harms
herms105626432herms
holms105117802holms
horas86333102horas
horns86125332horns
jorams154810532jorams
jorums15408092jorums
koras95927112koras
korma115913072korma
kormas124511232kormas
kors85933012kor_s
loams75619862loams
looms75124642looms
lords64923502lords
lores55045402lores
loris55329152loris
moms86539482mo_ms
moras76438782moras
mores76249642mores
morns75527442morns
mors65950062mor_s
morts75533562morts
noms65636402no_ms
noris54928272noris
norm66429812norm_
ogams84112682ogams
ogres65818632ogres
ohms95514032_ohms
oms56337512_o_ms
orbs66626252_orbs
orcs67025432_orcs
ores46056682_ores
ors35750112_or_s
orts46538332_orts
perms95524512perms
poems95715552poems
poms87037742po_ms
pores75849032pores
porks115124142porks
porns75527342porns
ports75934592ports
proms95426412proms
roams74919612roams
roms67038962ro_ms
rooms75324682rooms
soms66239372so_ms
soras55041012soras
sorbs75022102sorbs
sords64527802sords
sores55454282sores
sorns55028422sorns
sorts54536662sorts
sorus54527582sorus
storms85814632storms
terms75523472terms
toms68343492to_ms
toras55540372toras
torcs75123762torcs
tores55352672tores
toros54336192toros
torrs53923562torrs
tors46157382tor_s
torts56138122torts
torus54329762torus
warms107726852warms
words95425072words
works125621902works
worm96129492worm_
wormy137514252wormy
worts88631182worts
yores85031322yores
zooms164415522zooms
zoris145320012zoris

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 Limit538001961.59333772.8
3Display Results1961960.0464260.9
 (SQL Overall)1786911961.95291542.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.