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

212 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
forms10532705(None) 
corms95626221corms
dorms85723831dorms
farms106324951farms
firms105217421firms
foams105017951foams
forams115115911forams
forbs105720801forbs
fords95328181fords
fores85847101fores
forks125324681forks
form95836871form_
forme105225991forme
formes114623711formes
forts86034451forts
forums114611841forums
gorms85619591gorms
norms76019301norms
worms105320751worms
arms66137492_arms
barms96128462barms
berms95323662berms
booms95427122booms
boras75938302boras
bores76448252bores
borks115727702borks
borts76735452borts
cords86030622cords
cores76361852cores
corks116028272corks
corm85735372corm_
corns76034762corns
corps95927042corps
cors66656442cor_s
deforms1337802deforms
derms85022892derms
doms76239572do_ms
dooms85321342dooms
dorks105724442dorks
dorm76834622dorm_
dormy115817462dormy
dorps85419222dorps
dorrs65520592dorrs
dors56747602dor_s
doums85417642doums
fards96629842fards
fares85852872fares
farls85731112farls
farm95934532farm_
faros85532022faros
farts88336842farts
fems96428702f_ems
feres86038182feres
fermi103914162fermi
fermis114313502fermis
ferns85220082ferns
films105617962films
fiords10498622fiords
fires85740752fires
firm96026452firm_
firns86018542firns
firs76637712fir_s
fjords17405352fjords
flams105125012flams
floras94715692floras
foals85721692foals
foam97127172foam_
foamy135313202foamy
fobs96034272fo_bs
focus105815882focus
foes76543442fo_es
fogs87035002fo_gs
fohns117310782fohns
foils85025812foils
foins85523382foins
folds95221692folds
folks126017122folks
fonds95824822fonds
fons76943892fo_ns
fonts86124752fonts
foods95924162foods
fools86824202fools
foots85528282foots
fops96532682fo_ps
for66952072for__
fora75937392for_a
foram105124932foram
foray115023972foray
forays124813002forays
forb97131332for_b
forby135317672forby
force105324272force
forces114422132forces
ford86835492for_d
fordo97218652fordo
fore78351472for_e
forest94926742forest
forge95126942forge
forges105024262forges
forgo94418332forgo
fork115930942for_k
forky156119642forky
formal113215202formal
formals123312892formals
format113021352format
formats123113572formats
formed125021172formed
formee113919942formee
former114221402former
formers128217952formers
formic13310452formic
formol112910332formol
formols12299412formols
formyl14276442formyl
formyls15235702formyls
fort76456442for_t
forte86131462forte
fortes95327182fortes
forth116222672forth
fortis95418612fortis
forty114824272forty
forum108318762forum
foss76431642fo_ss
fouls87221432fouls
fours85521492fours
fowls115518892fowls
foxes156321092foxes
foys105628292fo_ys
froes86126692froes
frogs96220772frogs
from96923922from_
frons86124042frons
frows116623102frows
furls85322052furls
furs76735042fur_s
germs85118872germs
gores65740372gores
gorm75529392gorm_
gorps85316992gorps
harms106829012harms
herms105626432herms
holms105117802holms
horas86333092horas
horns86125332horns
informs1248062informs
jorams154810532jorams
jorums15408092jorums
koras95927112koras
korma115913072korma
kormas124511232kormas
kors85933012kor_s
loams75619862loams
looms75124642looms
lords64923502lords
lores55045402lores
loris55329152loris
moms86539482mo_ms
moras76438762moras
mores76249642mores
morns75527442morns
mors65950062mor_s
morts75533562morts
noms65636402no_ms
noris54928272noris
norm66429812norm_
ohms95514032_ohms
oms56337512_o_ms
orbs66626252_orbs
orcs67025432_orcs
ores46056682_ores
ors35750112_or_s
orts46538332_orts
perms95524512perms
poems95715552poems
poms87037742po_ms
pores75849032pores
porks115124142porks
porns75527342porns
ports75934592ports
proms95426402proms
reforms1239812reforms
roams74919612roams
roms67038962ro_ms
rooms75324682rooms
soms66239372so_ms
soras55041012soras
sorbs75022102sorbs
sords64527802sords
sores55454282sores
sorns55028412sorns
sorts54536662sorts
sorus54527582sorus
storms85814602storms
terms75523472terms
toms68343492to_ms
toras55540372toras
torcs75123762torcs
tores55352672tores
toros54336192toros
torrs53923562torrs
tors46157382tor_s
torts56138122torts
torus54329762torus
warms107726852warms
words95425072words
works125621902works
worm96129482worm_
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.0931921408.6
2DLD Change Limit538002121.69031834.3
3Display Results2122120.0464608.7
 (SQL Overall)1786912121.82997698.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.