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

154 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
freebies133787(None) 
freebees1345351freebees
freebie1236041freebie_
creepies1239612creepies
freebase1344852freebase
freebases1444932freebases
freebee1238042freeb_ee
freesias1146332freesias
freezes193310352free_zes
frenzies2037712frenzies
greenies9312672greenies
preemies12512192preemies
arteries8321483arteries
beebees1138013_beebees
beedies10314203_beedies
breeches15258673breeches
breezes18318693bree_zes
breezier1934533breezier
breeziest2035063breeziest
breweries1447583breweries
brumbies1436533brumbies
creepie1137483creepie_
creepier1236253creepier
creepiest1337063creepiest
creeses93914623cree_ses
creeshes1336953creeshes
derbies103016053_derbies
drearies92313413drearies
dweebier1442223dweebier
dweebiest1542663dweebiest
faeries104118993f_aeries
fakeries1559833fakeries
feeble1138253f_eeble_
feebler1235823f_eebler
feeblest1336913f_eeblest
feebs106112683f_eeb__s
feezes184412613f_ee_zes
fellies104119743f_ellies
ferities111416713ferities
ferlies103216693f_erlies
ferneries1239043ferneries
ferries103521083f_erries
fineries112416743fineries
fireflies1545353fireflies
fleabites1443613fleabites
fleeces12399643flee_ces
fleeches16287083fleeches
fleecier1334763fleecier
fleeciest1434873fleeciest
forgeries13310003forgeries
freakier15246483freakier
freakiest16206693freakiest
freckles17126383freckles
freebased1543463freebased
freebaser1443683freebaser
freebasers1543003freebasers
freeboot1345933freeboot
freeboots1444043freeboots
freeborn1344803freeborn
freedmen1444553freedmen
freedoms1445433freedoms
freeing113713913free_ing
freemen1238463free_men
freeness11710443freeness
freers94717303free__rs
frees86131393fr_e__es
freesia1046323freesi_a
freewares1545943freewares
freeways1744723freeways
freewill1443413freewill
freewrites1643573freewrites
freeze18349513free_ze_
freezer19348523free_zer
freezers20307173freezers
freezing21308323freezing
frenches163311633frenches
frenetics1444603frenetics
frenzied2144043frenzied
freres94716173fr_e_res
frescoes1357833frescoes
freshes133515823fr_eshes
frettier1156593frettier
frettiest1267063frettiest
friaries11310083friaries
fribbles15287713fribbles
fries85535603fr___ies
friezes19418913frie_zes
frisbees13295013frisbees
frizzies19315933frizzies
furmeties1446573furmeties
grebes93813613gr_eb_es
greedier1036083greedier
greediest1147553greediest
greenie8310123greenie_
greenier938713greenier
greeniest1039033greeniest
gremmies1355993gremmies
heresies11312693heresies
kebbies1537253_kebbies
kneesies1245543kneesies
newbies12147423_newbies
orreries8310123orreries
peeries93623023_peeries
prebids12399883pr_ebids
predries112714383predries
preedits1168763preedits
preemie11310563preemie_
premies113823063pr_emies
preppies1149693preppies
pretties10615133pretties
prexies163415003pr_exies
rabbies113416053_rabbies
rabies85226023_r_abies
readies83324713_readies
rebbes10313533_r_ebbes
rebids94015533_r_ebids
redefies12710163_redefies
redenies9615713_redenies
redries83721713_redries
reedier83815303_reedier
reediest92815423_reediest
reedits8511743_reedits
reefier102912553_reefier
reefiest112811483_reefiest
reekier113111123_reekier
reekiest122711313_reekiest
reemits9611303_reemits
reeves94721493_ree_ves
reflies104418533_reflies
refries104419733_refries
reifies104218283_reifies
relies65036423_r_elies
remedies11310553_remedies
replies94521043_replies
reties65436193_r_eties
retries74129073_retries
reveries112518513_reveries
rubbies114114113_rubbies
rubies84420343_r_ubies
rugbies10339353_rugbies
sheenies111411543sheenies
steelies8312553steelies
sweenies11148763sweenies
sweeties11159723sweeties
treaties8316983treaties
trebles9311443tr_ebles
trembles1237353trembles
trendies9312213trendies
trilbies1037693trilbies
tweenies11146393tweenies
veeries102916893_veeries
weenies102915093_weenies
weepies122811743_weepies
wheelies1437863wheelies

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.450397091.1
2DLD Change Limit1461621546.75021653.6
3Display Results1541540.0632444.4
 (SQL Overall)1786911547.26324602.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.