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

194 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
frivol123511(None) 
frijol1634121frijol
frivols1334741frivols
drivel105110382drivel
frijole1734582frijole
frill84917562fri_ll
frivoled1534042frivoled
frivoler1443932frivoler
rival85216502_rival
triol55521362tri_ol
amidol9489573amidol
argol65317263ar_gol
ariel55228973ari_el
aril45843023ari__l
arrival1037563arrival
arval86017013ar_val
arvo76023433ar_vo_
arvos86015663ar_vos
bravo105214343bravo_
bravos114711393bravos
bricole112810493bricole
bridal9511453bridal
brill74819953bri_ll
brillo84211003brillo
brio65432493bri_o_
brios74725723bri_os
bristol937043bristol
cibol9512023_cibol
civil103411933_civil
cresol8310213cresol
diol57329133_di_ol
divot95723073_divot
drill64718263dri_ll
drive95318003driv_e
drivels11397923drivels
driven105210143driven
driver104714493driver
drives105117113drives
drool65416103dr_ool
ervil8310303er_vil
fail74840243fai__l
favor114712453f_avor
feijoa1642223feijoa
ferial94621253feri_al
fervor1235643fervor
fico95824593f_ico_
fido87726403f_ido_
fidos95819053f_idos
fil65447143f_i__l
fill75540193f_i_ll
fillo84319783f_illo
filo76034283f_ilo_
filos86125383f_ilos
final83922033f_inal
fino76034693f_ino_
finos86226953f_inos
five107629743f_iv_e
fiver116024943f_iver
fives116027363f_ives
flavor1236663flavor
foil76433913foi__l
foison948933foison
fool75330593f__ool
formol112910333formol
frail85220213fr_ail
frazil1847223frazil
friable122612563friable
friar85414273fri_ar
friarly13316213friarly
friars93812093friars
friary124010093friary
fribble14287783fribble
fridge11379253fridge
fried95322913fri_ed
friend10388933friend
frier85225843fri_er
friers94718933friers
fries85535603fri_es
frieze18378143frieze
frig85424503fri__g
friges104116483friges
fright133715243fright
frigid1136923frigid
frigs96019273fri_gs
frijoles1834373frijoles
frills94414223frills
frilly124111443frilly
fringe104013953fringe
fringy13309263fringy
frise85322453fri_se
frisee94217993frisee
frises94124273frises
frisk125312373fri_sk
frisks13479263frisks
frisky16406673frisky
frisson1045313frisson
frit77044473fri__t
frites94922483frites
frith115922033fri_th
friths124313583friths
frits86129103fri_ts
fritt86129413fri_tt
fritts94613193fritts
fritz176020773fri_tz
frivolers1543473frivolers
frivoling1644493frivoling
frivolity1843063frivolity
frivolled1642383frivolled
frivoller1542433frivoller
frivolous1553163frivolous
friz166324343fri__z
frized193510683frized
frizer184011283frizer
frizes184015463frizes
frizz165512623fri_zz
frizzle18367043frizzle
frizzly21455793frizzly
frizzy20555833frizzy
fro65530643fr__o_
froe75329993fr__oe
frog85624363fr__og
from96923923fr__om
frow106425053fr__ow
frugal1036393frugal
gravel105313823gravel
grill64617893gri_ll
griot65328413gri_ot
grison7310103grison
grivet103517823grivet
grovel104310543grovel
idol56818633__idol
krill94213643kri_ll
nicol71113293_nicol
nival84915773_nival
ogival1035873ogival
orcinol944703orcinol
oriel54920423ori_el
oriole6814293ori_ole
orison6411663orison
pivot106523873_pivot
prill74117943pri_ll
primal104014623primal
primo95017913primo_
primos104514423primos
prion75119993pri_on
prior74316173pri_or
prison8514023prison
privet113821343privet
privily15207623privily
privy13439833priv_y
quinol15357973quinol
ravel84621513_ravel
revel84423163_revel
revolt9316223_revolt
rial45938093_ri_al
riel46432383_ri_el
rigor62714053_rigor
rill45140903_ri_ll
riot45947213_ri_ot
rivals94213183_rivals
rive75537723_riv_e
rived94825613_rived
riven85121623_riven
river85731693_river
rives85336003_rives
rivet85636363_rivet
riyal84413433_riyal
shrivel13479403shrivel
snivel9368853snivel
swivel12369323swivel
thiol87616043thi_ol
travel94112983travel
trial54926353tri_al
tribal8611133tribal
tricot8317753tricot
trifold1136243trifold
trigo65716053trigo_
trigon74513103trigon
trigos74214173trigos
trill55122933tri_ll
trinal6516963trinal
trio45233343tri_o_
triols66117803tri_ols
trios55528093tri_os
tripod9399853tripod
tripoli937133tripoli
tripos84014923tripos
triton63914893triton
trivet93721883trivet
trivia938503trivia
trivial1038713trivial
urial54823023uri_al
urinal6614123urinal
viol76523593_vi_ol

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.376475242.0
2DLD Change Limit1127161945.67019879.4
3Display Results1941940.0633079.4
 (SQL Overall)1786911946.10929250.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.