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

123 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
frijole173458(None) 
frijol1634121frijol_
frijoles1834371frijoles
bricole112810492bricole
friable122612562friable
fribble14287782fribble
frivol1235112frivol_
frivoled1534042frivoled
frivoler1443932frivoler
frivols1334742frivols
frizzle18367042frizzle
oriole6814292ori_ole
airhole1048273airhole
anisole71010833anisole
areole61017283ar_eole
ariose64818723ari_ose
armhole1236943armhole
brickle15279933brickle
bricoles122610303bricoles
bridle94115463bri_dle
brindle104210103brindle
bristle91910103bristle
brittle9168603brittle
cajole154011183_cajole
cariole9818343cari_ole
citole8311503_citole
creole8913733cr_eole
crimple13408693crimple
cringle103010353cringle
crinkle13359413crinkle
cripple13378583cripple
dariole8711163dari_ole
dipole91112853_dipole
dribble12368603dribble
drizzle16285913drizzle
faille93414743fai_lle
farinose1136463farinose
feijoa1642223feijo_a
feijoas1742323feijoas
fickle153912973f_ickle
fiddle113613383f_iddle
file75446643f_i__le
fille84327403f_i_lle
filose96112503f_ilose
fimble133611753f_imble
finale94116763f_inale
fipple13329063f_ipple
fizzle17369713f_izzle
foible11410383foi_ble
foveole13106873foveole
foxhole2045073foxhole
fragile1147843fragile
frazzle18305223frazzle
freckle16106643freckle
friarly13316213friarly
fribbled16305743fribbled
fribbler15265953fribbler
fribbles15287713fribbles
fridge11379253fri_dge
frieze18378143fri_eze
frigate11311063frigate
frill84917563fri__ll
frilled113911603fri_lled
friller104111743fri_ller
frills94414223fri_lls
frilly124111443fri_lly
fringe104013953fri_nge
frisbee12298513frisbee
frise85322453fri__se
frisee94217993fri_see
frivolers1543473frivolers
frivolled1642383frivolled
frivoller1542433frivoller
frizzled20325703frizzled
frizzler19345843frizzler
frizzles19297283frizzles
frizzly21455793frizzly
froe75329993fr__o_e
frore86218803fr__ore
froze174515653fr__oze
fryable15277463fryable
gribble12297273gribble
griddle1035503griddle
grille74315743gri_lle
gripple12416613gripple
gristle8169223gristle
grizzle16306113grizzle
jole117233823___jole
orioles7412993ori_oles
pinole83218783_pinole
prickle153611013prickle
prole74527793pr__ole
resole64624183_resole
ribose839893_ribose
riddle83915713_riddle
riffle124210233_riffle
rifle85518333_ri_fle
rile45650533_ri__le
rille55728733_ri_lle
rimose8310593_rimose
rimple103814583_rimple
ripple103413913_ripple
rissole739783_rissole
role45851823_r__ole
triable92515393triable
triazole1744153triazole
trickle133613443trickle
trifle94012883tri_fle
trifold1136243trifold
trindle83311363trindle
triode75311893tri_ode
triol55521363tri_ol_
triolet73219523tri_olet
triols66117803tri_ols
triose64715383tri_ose
triple84215923tri_ple
tripoli937133tripoli
trisome9310223trisome
tritone73613883tritone
urinose738483urinose
variole10711593vari_ole
wriggle12316213wriggle
wrinkle14296923wrinkle

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271235.73323378.2
3Display Results1231230.0333727.3
 (SQL Overall)1786911236.17228951.9
 
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.