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

156 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
friskets1532626(None) 
briskets14346561briskets
friskers15337371friskers
frisket143811771frisket_
briskest14337802briskest
brisket134413402brisket_
crickets16418122crickets
flaskets1534602flaskets
freshets14298672freshets
frisbees13295012frisbees
frisees104411692fris_ees
frises94124272fris_e_s
frisked15478822friske_d
frisker14389272friske_r
friskiest1636232friskiest
frisks13479262frisk__s
prickets16329082prickets
rickets134915092_rickets
riskers114011992_riskers
trinkets1237142trinkets
arises65233803aris_e_s
baskets135111833_baskets
boskets13409473_boskets
brackets163310433brackets
briquets1934853briquets
brises84927613bris_e_s
brisked144210003briske_d
brisker134210293briske_r
briskness1544773briskness
brisks124611403brisk__s
brisses94314313brisse_s
brockets16328123brockets
bruskest14315903bruskest
caskets133910173_caskets
cressets10309103cressets
cricket154716953cricket_
crises84529433cris_e_s
crispens12286253crispens
crispers12309443crispers
crispest12177373crispest
crockets16339543crockets
crusets93811043crus_ets
driblets11266093driblets
drinkers13277823drinkers
feists94915313feis__ts
fidgets12388763f_idgets
filets94718953f_i_lets
fillets103414753f_illets
firsts95110923firs__ts
fishers134714723f_ishers
fishes125221343f_ishe_s
fishnets1445633f_ishnets
fists85527543f_is__ts
flasket1439733flasket_
flickers17338883flickers
foists95413983fois__ts
fraises104215693frais_e_s
frankers15348353frankers
frankest1536963frankest
frasses104314513frasse_s
freshens14298313freshens
freshes133515823freshe_s
freshest143010583freshest
freshet133416643freshet_
fresnels1135233fresnels
frets85523403fr___ets
fridges12369483fridge_s
friers94718933fri__ers
fries85535603fri__e_s
friezes19418913frieze_s
frigates12310933frigates
friges104116483fri_ge_s
frights14339623fri_ghts
frillers11349873frillers
fringes113514103fringe_s
frisbee12298513frisbe_e
frise85322453fris_e__
frisee94217993fris_e_e
frisette1195483frisette
frisettes1295363frisettes
friseur1033673fris_eur
friseurs1133303friseurs
frisk125312373frisk___
friskier1535193friskier
friskily1834503friskily
friskiness1744463friskiness
frisking16268363frisking
frisky16406673frisk__y
frissons1145043frissons
frites94922483fri_te_s
frits86129103fri___ts
fritters113810783fritters
fritts94613193fri__tts
fritzes19329453fritze_s
frizers19329553fri_zers
frizes184015463fri_ze_s
frizzers19335103frizzers
frizzes18338183frizze_s
froglets1235263froglets
frosteds12305663frosteds
frosts94214623fros__ts
fruitlets1243173fruitlets
gaskets12348153_gaskets
griskins1335953griskins
gristers94013413gristers
grists74716483gris__ts
grivets11357973gri_vets
irises64221173iris_e_s
islets64513083__islets
kismets13306883_kismets
krises105016083kris_e_s
missets94516573_missets
muskets13258643_muskets
pickets154314183_pickets
presets94216423pres_ets
prickers163710673prickers
pricket153616443pricket_
prinkers143010393prinkers
prises84133173pris_e_s
prisses94816713prisse_s
privets122910053pri_vets
rackets134916873_rackets
resets65427613_res_ets
riblets93412553_riblets
rickety16478313_rickety
rickeys16548983_rickeys
rillets74216153_rillets
risers64624783_ris_ers
rises55244043_ris_e_s
risked115514633_riske_d
risker105414493_riske_r
riskiest12310133_riskiest
riskless1235763_riskless
risks94917063_risk__s
rivets94417113_ri_vets
rockets134615363_rockets
rosets65819953_ros_ets
russets738163_russets
thickets17287083thickets
tickets134113683_tickets
trickers143812813trickers
trijets14308263tri_jets
trikes105419493tri_ke_s
trinket11314813trinket_
triolets83410143triolets
triplets103510263triplets
trippets12357423trippets
trisects1035983trisects
triskele1244573triskele
triskeles1344273triskeles
trivets103911583tri_vets
whiskers18306773whiskers
whiskeys21353383whiskeys
wickets164010943_wickets
wristlets1244473wristlets
wrists95415643wris__ts

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.423422437.4
2DLD Change Limit1461621567.45319611.2
3Display Results1561560.0632476.2
 (SQL Overall)1786911567.93922508.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.