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

204 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
froglet1131006(None) 
froglets1235261froglets
droplet10312112droplet
forget106326392forg_et
frogged13408492frogged
frogmen1335892frogmen
frontlet1147652frontlet
goglet84618582_goglet
reglet73724232_reglet
aglet65534143__aglet
aiglet74224193_aiglet
argle65421563ar_gle_
argled85314543ar_gled
argles75218483ar_gles
armlet84118193ar_mlet
bogle85821683_bogle_
bogles95020833_bogles
booklet132312643booklet
boomlet112412273boomlet
brocket154013383brocket
brogue94211033brogue_
brogues10719823brogues
broiled103811423broiled
broiler92911753broiler
brooklet1456403brooklet
collet84030363_collet
corslet9318063corslet
crochet143616663crochet
crocket154615673crocket
croquet1859683croquet
crosslet1049593crosslet
crownet123714113crownet
dogleg936323_dogleg
dragnet91211433dragnet
driblet103712243driblet
drogue8938333drogue_
drogues9398393drogues
drolled93810223drolled
droller84110283droller
drollest937353drollest
drooled9369203drooled
droplets1136063droplets
drugget10337613drugget
eaglet73722583_eaglet
fidget114216473fidg_et
filet85540163f__ilet
fillet95027083f_illet
flatlet10312253flatlet
flogged13528803flogged
flogger12449453flogger
floret9321123flo_ret
foaled104515963f_oaled
fogey125617873f_og_ey
fogged125518373f_ogged
fogger114414773f_ogger
fogie96719003f_ogie_
fogies104118063f_ogies
fogless1138193f_ogless
foiled104618403f_oiled
foley115222303f_o_ley
folles93820473f_olles
fooled104317823f_ooled
footle93914383footle_
footled113610763footled
footler104011863footler
footles103715713footles
foozle18369203foozle_
foozled20346893foozled
foozler19397593foozler
foozles19329543foozles
foreleg1137743foreleg
forgat104018583forg_at
forge95126943forg_e_
forged115519323forg_ed
forger104820763forg_er
forges105024263forg_es
forgets113813793forg_ets
forgoer1137683forgoer
forgoes11311353forgoes
forgot104318133forg_ot
fouled104315973f_ouled
fouler93614903f_ouler
foulest10313313f_oulest
fowled133914093f_owled
fowler123712583f_owler
fragged134010153fragged
fragile1147843fragile_
fragment1448373fragment
frailer10319943frailer
frailest1139493frailest
freshet133416643freshet
fret75845043fr___et
frigate11311063frigate
friges104116483frig_es
frigged13439053frigged
fright133715243frig_ht
frilled113911603frilled
friller104111743friller
frisket143811773frisket
frocked17439333frocked
froe75329993fro__e_
froes86126693fro__es
frog85624363frog___
frogeye1443813frogeye
frogeyed1642783frogeyed
frogeyes1543743frogeyes
froggier1354643froggier
froggiest1434913froggiest
froggy1434493frog_gy
froglike1634363froglike
frogman1335873frogman
frogs96220773frog__s
frolic1149203fro_lic
fronded12388863fronded
front85029223fro__nt
fronted114011273fronted
fronter103611583fronter
frontes104214163frontes
frontlets1244233frontlets
frore86218803fro_re_
frost84727833fro__st
frosted113211873frosted
frothed14288783frothed
frother133110153frother
frowned14348833frowned
frowner13429683frowner
frowst125512073fro_wst
froze174515653fro_ze_
frozen18408443fro_zen
frugged13387283frugged
fruitlet1146883fruitlet
fugle94915543f_ugle_
fugled114813693f_ugled
fugles104715783f_ugles
giglet83920273_giglet
goblet93219483_goblet
goglets9379783_goglets
gorget87123863gorg_et
grommet12268453grommet
growled12278163growled
growler11318973growler
guglet84018223_guglet
gurglet94412033gurglet
hogget114715763_hogget
hooklet142510813hooklet
howlet123518343_howlet
kinglet123114043kinglet
moonlet92413273moonlet
ogle56325053__ogle_
ogled75915963__ogled
ogler65917443__ogler
ogles65223183__ogles
owlet83324463__owlet
piglet93420923_piglet
piolet83225643pio_let
problem1335983problem
progged12409793progged
progger11319373progger
projet15315183pro_jet
prole74527793pro_le_
proleg94612113pro_leg
proles84627203pro_les
prophet14316033prophet
propjet1839913propjet
prowled13309903prowled
prowler123310013prowler
reflet94024233_reflet
reglets83512983_reglets
regret73723533_regret
relet54749823_r_elet
riblet84222443_riblet
rillet64828853_rillet
ringlet82818173ringlet
roble75223023_roble_
robles85321693_robles
rochet115423003_rochet
rocket125425283_rocket
roger64521413_rog_er
rogue66417533_rogue_
rogued84711473_rogued
rogues74617673_rogues
roiled74320053_roiled
role45851823_ro_le_
roles56747983_ro_les
rolled74220243_rolled
roller63919793_roller
rootlet73015733rootlet
roquet154415893_roquet
roset55945243_ro_set
roupet84218343_roupet
runlet63821413_runlet
singlet84120113singlet
sniglet83612413sniglet
toilet66228093_toilet
tonlet62924703_tonlet
triolet73219523triolet
triplet94319213triplet
trolled84312263trolled
troller73913173troller
trolley10328753trolley
violet92620923vio_let
wiglet105519153_wiglet
winglet113115983winglet
zooglea1733373zooglea

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340272047.28018410.3
3Display Results2042040.0802550.0
 (SQL Overall)1786912047.51623774.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.