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

140 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
dreamiest1222722(None) 
creamiest13248931creamiest
dreariest10229121dreariest
beamiest123212762_beamiest
creakiest15238592creakiest
creasiest11229942creasiest
dreamier11287292dreamie_r
dreaminess1345312dreaminess
dreamless1243512dreamless
drearies92313412drearies_
dreggiest12124542dreggiest
dressiest1036822dressiest
freakiest16206692freakiest
gleamiest1235312gleamiest
greasiest10208562greasiest
readiest93719042_readiest
seamiest102715422_seamiest
steamiest1138412steamiest
streamiest1245122streamiest
beadiest113815533_beadiest
beakiest143313463_beakiest
bleariest1158853bleariest
brakiest143912243br_akiest
breathiest1545993breathiest
breeziest2035063breeziest
broomiest1356913broomiest
ceramist12310933cerami_st
crampiest15268623cr_ampiest
craziest19319923cr_aziest
creamier12319063creamie_r
creaminess1446203creaminess
creepiest1337063creepiest
crepiest12310383cre_piest
croakiest15167173croakiest
crummiest1545563crummiest
dampest12411043d__ampest
deadest93014883d_ea_dest
deadliest1138183d_eadliest
deafest112911513d_ea_fest
dearest83618673d_ea_rest
dearies83526273d_earies_
deediest102912253d_eediest
demies94825803d_e_mies_
dewiest11312343d_e_wiest
digamies1238643digamies_
digamist1248213digami_st
doomiest112910453d_oomiest
drabbest13295663dr_abbest
draffiest1644363draffiest
draftiest1335943draftiest
draggiest12126413draggiest
drawliest13166243drawliest
dreamboat1472973dreamboat
dreamed114310633dream_e_d
dreamer104110843dream_e_r
dreamers11369003dream_ers
dreamily1435143dreami_ly
dreaming124011063dreami_ng
dreams94513983dream__s_
dreamt94615713dream___t
dreamtimes1542193dreamtimes_
drearier9297923drearie_r
dreariness1146283dreariness
driest74722753dr___iest
driftiest1335943driftiest
drippiest1445373drippiest
drooliest1036343drooliest
droopiest1235743droopiest
drossiest1036523drossiest
drowsiest1334993drowsiest
druggiest12134973druggiest
drumliest1235433drumliest
dweebiest1542663dweebiest
dynamist1445343dynami_st
easiest72318773__easiest
elmiest9310743__elmiest
flamiest133111983_flamiest
foamiest13289853_foamiest
frettiest1267063frettiest
gamiest102816233__gamiest
gemmiest13227633_gemmiest
germiest11249923_germiest
grapiest112211933gr_apiest
greatest939863grea_test
greediest1147553greediest
greeniest1039033greeniest
gremmies1355993gremmies_
grimiest11299823gr_imiest
headiest123015553_headiest
heaviest143210443_heaviest
leadiest93314993_leadiest
leafiest113410893_leafiest
leakiest123212803_leakiest
leariest83117853_leariest
leaviest112910823_leaviest
loamiest102310213_loamiest
mealiest102215973_mealiest
meatiest102816793_meatiest
peakiest143513003_peakiest
peatiest103118813_peatiest
preachiest1746983preachiest
preemies12512193preemies_
premies113823063pre_mies_
preppiest1236983preppiest
prettiest1199803prettiest
queasiest1844313queasiest
queaziest2743243queaziest
raciest92820013_r_aciest
ramies84630463_r_amies_
rammiest12299933_rammiest
readies83324713_readies_
realest73322433_rea_lest
realist73225383_reali_st
rearrest8311603_rearrest
reediest92815423_reediest
reefiest112811483_reefiest
reekiest122711313_reekiest
rheumiest1442863rheumiest
rimiest93215853_r_imiest
roomiest102611993_roomiest
rummiest12299353_rummiest
sleaziest1836063sleaziest
smeariest1138123smeariest
sneakiest13176843sneakiest
steadiest1038523steadiest
stemmiest1335143stemmiest
streakiest1444773streakiest
sweatiest1238423sweatiest
teariest82417263_teariest
threadiest1444283threadiest
trampiest13227903tr_ampiest
treacliest1245383treacliest
treaties8316983treaties_
trendiest1038423trendiest
tressiest937883tressiest
tweakiest1634053tweakiest
uneasiest946563uneasiest
unreadiest1144803unreadiest
vealiest112513203_vealiest
weariest112914793_weariest

Search took 9 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 Filter1786911486410.423422437.4
2DLD Change Limit1486411407.73619214.2
3Display Results1401400.0602333.3
 (SQL Overall)1786911408.21921741.2
 
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.