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

146 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
frijol163412(None) 
frijole1734581frijole
frivol1235111frivol
feijoa1642222feijoa
frijoles1834372frijoles
frill84917562fri_ll
frivols1334742frivols
triol55521362tri_ol
amidol9489573amidol
argol65317263ar_gol
ariel55228973ari_el
aril45843023ari__l
bijou1458793_bijou
bricole112810493bricole
bridal9511453bridal
brill74819953bri_ll
brillo84211003brillo
brio65432493bri_o_
brios74725723bri_os
bristol937043bristol
cibol9512023_cibol
cresol8310213cresol
diol57329133_di_ol
drill64718263dri_ll
drivel105110383drivel
drool65416103dr_ool
fail74840243fai__l
feijoas1742323feijoas
ferial94621253feri_al
fico95824593f_ico_
fido87726403f_ido_
fidos95819053f_idos
fil65447143f_i__l
fill75540193f_i_ll
fillo84319783f_illo
filo76034283f_ilo_
filos86125383f_ilos
final83922033f_inal
fino76034693f_ino_
finos86226953f_inos
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
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
frivoled1534043frivoled
frivoler1443933frivoler
friz166324343fri__z
frized193510683frized
frizer184011283frizer
frizes184015463frizes
frizz165512623fri_zz
frizzle18367043frizzle
frizzly21455793frizzly
frizzy20555833frizzy
fro65530643fr__o_
froe75329993fr__oe
frog85624363fr__og
from96923923fr__om
frow106425053fr__ow
frugal1036393frugal
grill64617893gri_ll
griot65328413gri_ot
grison7310103grison
idol56818633__idol
krill94213643kri_ll
nicol71113293_nicol
orcinol944703orcinol
oriel54920423ori_el
oriole6814293ori_ole
orison6411663orison
prill74117943pri_ll
primal104014623primal
primo95017913primo_
primos104514423primos
prion75119993pri_on
prior74316173pri_or
prison8514023prison
quinol15357973quinol
rial45938093_ri_al
riel46432383_ri_el
rigor62714053_rigor
rill45140903_ri_ll
rioja1236303_rioja
riot45947213_ri_ot
rival85216503_rival
riyal84413433_riyal
thiol87616043thi_ol
trial54926353tri_al
tribal8611133tribal
tricot8317753tricot
trifold1136243trifold
trigo65716053trigo_
trigon74513103trigon
trigos74214173trigos
trijet133916553trijet
trill55122933tri_ll
trinal6516963trinal
trio45233343tri_o_
triols66117803tri_ols
trios55528093tri_os
tripod9399853tripod
tripoli937133tripoli
tripos84014923tripos
triton63914893triton
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.406440125.6
2DLD Change Limit1127161465.67319868.9
3Display Results1461460.0463173.9
 (SQL Overall)1786911466.12529174.0
 
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.