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 “fornent” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

232 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
fornent1031293(None) 
forwent13310531forwent
cornet84436732corne_t
ferment12315572ferment
fervent13310062fervent
foment113718302fo_ment
forest94926742for_est
forewent1439422forewent
forfeit1339202forfeit
forfend1435412forfend
forget106326392forge_t
forint9325022for_int
formant123416002formant
forspent1348162forspent
hornet94926432horne_t
horrent10313552horrent
mordent10313992mordent
orient6322532_orient
ponent82821592po_nent
portent93619642portent
sorbent92915242sorbent
torment9316172torment
torrent7313412torrent
adornment1246283adornment
anent54931843__anent
ardent73022613_ardent
argent74023663_argent
arpent84822093_arpent
bonnet85524633bonne_t
boreen8314313boreen_
boreens9310403boreens
borne77926793borne__
borneol936823borneol
brent75734133_br_ent
burnet84326173burne_t
carnet84732873carne_t
coagent10313983coagent
cogent9321003co_gent
coinvent1348183coinvent
comment1310317703comment
concent114422513concent
connect113515743connect
consent93723113consent
content94326153content
convent123919413convent
cornea84018923corne_a
corneal94414503corneal
corneas94717003corneas
corned95224523corne_d
cornel84020053corne_l
cornels94716663cornels
corner84625623corne_r
corners94723313corners
cornets94820573cornets
corniest102117303corniest
corning103720123corning
coronet94227173corone_t
correct11513983correct
corset85636223corse_t
corvet114626933corve_t
current9313693current
docent92918683do_cent
donnert82815533donnert
dormant102814373dormant
dormient1148453dormient
dorneck1444303dorneck
earnest7318733earnest
eminent9313843eminent
erodent8313823erodent
faineant1146743faineant
fainest10417703fainest
farness102912203farness
ferments13311473ferments
fernery1335813fernery
ferniest1132214153ferniest
ferninst11238313ferninst
ferret93021173ferre_t
figment1379743figment
finest94321733f_inest
firmest1239273firmest
fitment12710303fitment
floret9321123flor_e_t
fluent9313933f_luent
foemen11310523foemen_
foined105915013foine_d
foining113013453foining
foments122912053fo_ments
fondant11311143fondant
fondest11312403fondest
font77143753fo___nt
foramen12310533foramen_
foramens1337823foramens
forbear1237523forbear
force105324273force__
forced126316523force_d
forceps14466983forceps
forcer114917343force_r
forcers124215713forcers
forces114422133force_s
forcing134013753forcing
forded115020393forde_d
fording123717043fording
fordone1149383fordone
fore78351473for_e__
foreby1438633for_eby
foredo10510823for_edo
forefeet14129393forefeet
forefelt14117363forefelt
forefend1545603forefend
forego1038903for_ego
foregut1149163foregut
foremen12412923foremen_
fores85847103for_e_s
forests104114953for_ests
forfeits1445803forfeits
forfends1544833forfends
forgat104018583for_gat
forge95126943forge__
forged115519323forge_d
forger104820773forge_r
forgers115218183forgers
forgery14419303forgery
forges105024263forge_s
forgets113813793forgets
forging124114723forging
forgone1139343forgone
forgot104318133for_got
forints10411833for_ints
forked145217143forke_d
forker134717903forke_r
forkers144615783forkers
forkiest153812303forkiest
forking154014843forking
formants13269953formants
format113021353for_mat
forme105225993forme__
formed125021173forme_d
formee113919943forme_e
former114221403forme_r
formers128217953formers
formes114623713forme_s
forming133615733forming
fornix1636033forn_ix
forrit91916623for_rit
fort76456443for___t
forte86131463forte__
fortes95327183forte_s
fortune1068303fortune
foulest10313313foulest
fount84727033fo__unt
foxhunt2043173foxhunt
foxiest174310493foxiest
foziest194110943foziest
fraena938063f_raena
freest95318283f_reest
frena85915273f_r_ena
fret75845043f_r_e_t
friend10388933f_riend
fromenty1645243fromenty
front85029223f_r_ont
frozen18408443frozen_
fulgent1138903fulgent
funest94316863f_unest
funnest102912003funnest
furmenty1645293furmenty
garment10315233garment
garnet73928413garne_t
gerent73223093ger_ent
gorget87123863gorge_t
gorhen1038893gorhen_
gorhens1137183gorhens
goriest82218743goriest
gurnet74920873gurne_t
honest94822423ho_nest
horned105718703horne_d
hornets104113553hornets
horniest112814043horniest
horning113015003horning
hornist102314823hornist
kronen10348913kronen_
loment84021473lo_ment
margent10316693margent
moment103319683mo_ment
mordant10312403mordant
mordents1138813mordents
moreen8313343moreen_
moreens939963moreens
morgen9312203morgen_
morgens10310463morgens
morning103215043morning
nocent83217413no_cent
nonet54540843no_ne_t
orgeat7515033_orgeat
orients7311583_orients
ornament1049133_ornament
ornery938463_ornery
parent83230423par_ent
percent113520603percent
perpent112318813perpent
porniest103214313porniest
porrect1159743porrect
portend103411193portend
portents103512823portents
potent84223353po_tent
rent46661243__r_ent
reorient8613473reorient
rerent63832453rer_ent
rodent7519243ro_dent
sarment9318763sarment
serpent92916283serpent
solvent10310833solvent
sonant6621953so_nant
sonnet65923503sonne_t
soonest7415593soonest
sorbents10279133sorbents
sorbet83924083sorbe_t
sorest65028003sor_est
sorned74820043sorne_d
sorner64720393sorne_r
sorners73416873sorners
sorning83116813sorning
sprent84522383spr_ent
torments10310453torments
torrents838143torrents
torten65314353torten_
turgent8712393turgent
unrent63219783unr_ent
urgent73816043_urgent
varment12313243varment
worsen95513873worsen_
worsens104610263worsens
worset96726583worse_t

Search took 9 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 Filter1786911340270.390458182.1
2DLD Change Limit1340272327.89016986.9
3Display Results2322320.0802900.0
 (SQL Overall)1786912328.36021374.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.