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

120 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
frijoles183437(None) 
frijole1734581frijole_
bricoles122610302bricoles
fribbles15287712fribbles
frijol1634122frijol__
frivoled1534042frivoled
frivoler1443932frivoler
frivolers1543472frivolers
frivols1334742frivol_s
frizzles19297282frizzles
orioles7412992ori_oles
airholes1138033airholes
anisoles81010123anisoles
areoles71016953ar_eoles
armholes1347383armholes
brickles162810283brickles
bricole112810493bricole_
bridles104114473bri_dles
brindles113710223brindles
bristles101510433bristles
brittles10178653brittles
cajoles163712103_cajoles
carioles10817073cari_oles
citoles9312553_citoles
creoles9913323cr_eoles
crimples14308963crimples
cringles11329463cringles
crinkles14269163crinkles
cripples14298403cripples
darioles9710693dari_oles
dipoles101013753_dipoles
dribbles13348393dribbles
drizzles17295293drizzles
failles102914133fai_lles
feijoas1742323feijo_as
ficoes114613463f_ico_es
fiddles123212603f_iddles
files85441273f_i__les
filles94224523f_i_lles
fimbles143510663f_imbles
finales104016013f_inales
fipples14298653f_ipples
fizzles18339063f_izzles
foibles1238853foi_bles
foveoles1496643foveoles
foxholes2144693foxholes
frazzles19284813frazzles
freckles17126383freckles
friable122612563friable_
friaries11310083friaries
fribble14287783fribble_
fribbled16305743fribbled
fribbler15265953fribbler
fribblers16314193fribblers
fridges12369483fri_dges
fries85535603fri___es
friezes19418913fri_ezes
frigates12310933frigates
friges104116483fri__ges
frilled113911603fri_lled
friller104111743fri_ller
frillers11349873fri_llers
frills94414223fri__lls
fringes113514103fri_nges
frisbees13295013frisbees
frisees104411693fri_sees
frises94124273fri__ses
frites94922483fri__tes
fritzes19329453fri_tzes
frivol1235113frivol__
frivolled1642383frivolled
frivoller1542433frivoller
frivollers1642073frivollers
frivolous1553163frivolous
frizes184015463fri__zes
frizzes18338183fri_zzes
frizzies19315933frizzies
frizzle18367043frizzle_
frizzled20325703frizzled
frizzler19345843frizzler
frizzlers20293673frizzlers
froes86126693fr__o_es
gribbles13307363gribbles
griddles1145753griddles
grilles83715023gri_lles
gristles9189203gristles
grizzles17286193grizzles
joles125230833___joles
oriole6814293ori_ole_
pinoles93418703_pinoles
prickles162511093prickles
proles84627203pr__oles
resoles73823653_resoles
riboses9310443_riboses
riddles93215023_riddles
riffles133911163_riffles
rifles94217703_ri_fles
riles55343643_ri__les
rilles64725503_ri_lles
rimples113114223_rimples
ripples113513293_ripples
rissoles839113_rissoles
roles56747983_r__oles
triazoles1844393triazoles
trickles143013763trickles
trifles103814823tri_fles
trindles93211683trindles
triodes84012503tri_odes
triolet73219523tri_olet
triolets83410143tri_olets
triols66117803tri_ol_s
trioses75015653tri_oses
triples94616873tri_ples
tripolis1038713tripolis
triposes1039973triposes
trisomes1039833trisomes
tritones83413443tritones
varioles11711123vari_oles
wriggles13286263wriggles
wrinkles15296693wrinkles

Search took 8 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 Filter1786911461620.436409841.7
2DLD Change Limit1461621206.78321548.3
3Display Results1201200.0462608.7
 (SQL Overall)1786911207.26524596.1
 
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.