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

280 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
frigid113692(None) 
rigid7913891_rigid
fried95322912fri_ed
friend10388932friend
frig85424502frig__
friges104116482friges
frigged13439052frigged
fright133715242fright
frigidly1643122frigidly
frigs96019272frig_s
fringed123611522fringed
frized193510682frized
fulgid1137042fulgid
origin7311032origin
trifid1039062trifid
afraid1049723afr_aid
algid75415583_algid
aramid93315613aramid
argil65116883ar_gil
arid57642713ar__id
aright103817663aright
ariled75620323ariled
aroid65428343ar_oid
bifid11910703_bifid
braid85822263br_aid
briard94311293briard
bribed115312843bribed
bridged12339033bridged
brig76528033brig__
brigade1136493brigade
brigand1136643brigand
bright124215923bright
brigs85823223brig_s
brined95118413brined
bromid112612893bromid
cricoid1239253cricoid
cried84624293cri_ed
cringed113312403cringed
crinoid1039943crinoid
crisic103611843crisic
crisis83716343crisis
critic103616813critic
digit73825273_digit
dried75321383dri_ed
droid74218543dr_oid
druid74111323dr_uid
ericoid1049893ericoid
fadged124712363fadged
fagged124717703fagged
fagin9216573f_agin
failed105421603failed
faired105915773faired
fanged114318233fanged
feign94210713feig_n
feigned1245353feigned
feigns10407753feigns
feirie939553feirie
felid94717173f_elid
fervid1337513fervid
fetid93715983f_etid
ficin103516723f_icin
fid76847693f___id
fidged124610933fidged
field95015323f_ield
fiend95312983f_iend
fifed125115973f_ifed
fig76242833f_ig__
figged124013893figged
fight124027093f_ight
figs85332643f_ig_s
filed95331903f_iled
find87532603f_i_nd
fined94930503f_ined
finis86824263f_inis
fiord94313343f_iord
fired94829743f_ired
firkin1337823firkin
firmed125411883firmed
fixed165416953f_ixed
fixit154819303f_ixit
fizgig2032973fizgig
flied96519433fli_ed
flight134014813flight
flited104616583flited
florid10311453florid
fluid94013963f_luid
foetid10510513foetid
fogged125518373fogged
fogie96719003f_ogie
foiled104618403foiled
foined105915013foined
foraged124812283foraged
forbid123312433forbid
fordid113512053fordid
foredid1238503foredid
forged115519323forged
frag85126273frag__
fragged134010163fragged
fragile1147843fragile
frags96322173frag_s
frail85220213fr_ail
framed125116523framed
fraud939863fr_aud
frayed135012163frayed
frazil1847223frazil
freed95223543fr_eed
freight1447603freight
fremd115010323fr_emd
friar85414273fri_ar
friars93812093friars
friary124010093friary
fridge11379253fridge
fridges12369483fridges
friends11396743friends
frier85225843fri_er
friers94718933friers
fries85535603fri_es
frieze18378143frieze
frigate11311063frigate
frigging14268953frigging
frighted1657173frighted
frights14339623frights
frigidity1743013frigidity
frijol1634123frijol
frill84917563fri_ll
frilled113911603frilled
frills94414223frills
frilly124111443frilly
fringe104013953fringe
fringes113514103fringes
fringier1236553fringier
fringing133010903fringing
fringy13309263fringy
frise85322453fri_se
frisee94217993frisee
frises94124273frises
frisk125312373fri_sk
frisked15478823frisked
frisks13479263frisks
frisky16406673frisky
frit77044473fr__it
frites94922483frites
frith115922033fri_th
friths124313583friths
frits86129103fri_ts
fritt86129413fri_tt
fritted113611333fritted
fritts94613193fritts
fritz176020773fri_tz
frivol1235113frivol
friz166324343fr__iz
frizer184011283frizer
frizes184015463frizes
frizing203310873frizing
frizz165512623fri_zz
frizzed19375973frizzed
frizzy20555833frizzy
frog85624363frog__
frogged13408493frogged
froggy1434493froggy
frogs96220773frog_s
frolic1149203frolic
frond95316343fr_ond
frug86517103frug__
frugal1036393frugal
frugged13387293frugged
frugs96114283frug_s
fruit85122223fr_uit
fruited11389093fruited
fucoid1237893fucoid
fudged125212823fudged
fugged124615383fugged
fugio9310923f_ugio
fungi95014133fungi_
fungic12387813fungic
fungoid1245253fungoid
gid57047273___gid
gravid113710983gravid
grid65829613gr__id
grided95117043grided
grig65424773grig__
grigri833853grigri
grigris934093grigris
grigs75318193grig_s
grimed104714093grimed
grind75917563gri_nd
griped104114713griped
imid76122293__imid
irid55927173__irid
iridic9328743iridic
irised73913153irised
iritic83213823iritic
iritis63113733iritis
lipid85916173_lipid
livid96714423_livid
nitid61817833_nitid
nonrigid1044863nonrigid
opioid9310083opioid
orchid1289573orchid
orgic8311823or_gic
oribi7311093oribi_
oribis838833oribis
origan7310693origan
origins8310463origins
pongid104111583pongid
prebid113512843prebid
priced115018883priced
prided103618033prided
pried84426863pri_ed
prig75924873prig__
prigged12398933prigged
prigs85219703prig_s
primed115118913primed
primi95017403primi_
prised94322203prised
prized184415393prized
rabid84520783_rabid
raged74829453_raged
ragi56032283_ragi_
ragis66325603_ragis
raid55243073_r_aid
ranid66429333_ranid
rapid86422033_rapid
rebid85121363_rebid
redid74922393_redid
regild8149773_regild
resid64124093_resid
riced85825543_riced
ricin74620213_ricin
rid46754633_r__id
ridged94014223_ridged
ridgil8316823_ridgil
rig46748123_rig__
rigged94517403_rigged
right94430503_right
rigidly1235533_rigidly
rigor62714053_rigor
rigs55137593_rig_s
riled65833253_riled
rimed84826373_rimed
rind56535603_ri_nd
ringed84623843_ringed
riped85226433_riped
rived94825613_rived
saiyid10167413saiyid
sigil63515503_sigil
strigil837263strigil
teiid6312533tei_id
timid84815733_timid
tragi64717173tragi_
tragic93811553tragic
trepid9310083trepid
triacid1038593triacid
triad65217723tri_ad
triaged92810443triaged
triced95518673triced
tried65026913tri_ed
trig55528163trig__
trigged10359853trigged
trigly103810943trigly
trigo65716053trig_o
trigon74513103trigon
trigos74214173trigos
trigs65423063trig_s
trined74920713trined
trioxid1546613trioxid
tripod9399853tripod
trivia938513trivia
turgid868023turgid
urged75316033ur_ged
ursid6311483ur_sid
vigia94813273_vigia
vigil94313003_vigil
virgin1038083virgin
virid94116043_virid
viroid10411523viroid
vivid125112313_vivid
wried95518563wri_ed
wright133713513wright
wringed123710193wringed

Search took 7 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 Filter1786911127160.533335255.2
2DLD Change Limit1127162805.79619447.2
3Display Results2802800.0933010.8
 (SQL Overall)1786912806.42227824.8
 
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.