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

232 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
dreamier1128729(None) 
creamier12319061creamier
dreamer104110841dream_er
drearier9297921drearier
beamier113411942_beamier
creakier14328332creakier
creamer113714092cream_er
creasier103210192creasier
dreamed114310632dream_ed
dreamers11369002dream_ers
dreamiest12227222dreamiest
dreamily1435142dreamily
dreaming124011062dreaming
drearies92313412drearies
dreggier1193552dreggier
dressier956862dressier
freakier15246482freakier
gleamier1144912gleamier
greasier9298082greasier
premier113515632pre_mier
readier83117422_readier
reamer84325212_ream_er
recamier1237602_recamier
seamier93114632_seamier
steamier1048302steamier
streamier1155762streamier
beadier103513913_beadier
beakier134012163_beakier
blearier1037333blearier
brakier133812363br_akier
brasier94516753br_asier
brazier183911473br_azier
breacher153011503breacher
breaker133912923brea_ker
breamed124011593bream_ed
breaming133612513breaming
breather133610593breather
breathier1435383breathier
breezier1934533breezier
brevier1237763bre_vier
broomier1236873broomier
crammer134010963cr_ammer
crampier14288903cr_ampier
crazier183610743cr_azier
creamed123913713cream_ed
creamers124111313cream_ers
creamery15385983cream_ery
creamiest13248933creamiest
creamily1536363creamily
creaming133413143creaming
creaser94415743crea_ser
creepier1236253creepier
crepier1139743cre_pier
croakier14436263croakier
crummier1435603crummier
dammer114317933d__ammer
damner95213433d__amner
damper114117753d__amper
deader84220473d_ea_der
deadlier1036863d_eadlier
deafer104114813d_ea_fer
deair65817193d_ea_i_r
dealer74122143d_ea_ler
dearer74822803d_ea_rer
dearie73319813d_earie_
dearies83526273d_earies
decrier102713553d_ecrier
deedier93011593d_eedier
defamer132710323defam_er
defier105118653d_e_fier
deifier113013123d_eifier
demies94825803d_e_mies
denier74420693d_e_nier
deranger1037353deranger
dernier83011943d_ernier
dewier104013463d_e_wier
diemaker1545593diemaker
digamies1238643digamies
doomier103610123d_oomier
drabber12438593dr_abber
draffier1574323draffier
drafter11449433dr_after
draftier1285263draftier
dragger10309173dr_agger
draggier11135773draggier
drainer83012843dr_ainer
drammed13378073dr_ammed
draper94315693dr_a_per
drawer104711363dr_a_wer
drawler11338593dr_awler
drawlier12225253drawlier
dreaded103612023drea_ded
dreading113712803dreading
dream85120393dream___
dreamful1452963dreamful
dreaminess1345313dreaminess
dreamless1243513dreamless
dreamlike1642753dreamlike
dreams94513983dream__s
dreamt94615713dream__t
dreamtime1442343dreamtime
dreamtimes1542193dreamtimes
dreamy12509993dream__y
drear65016903drea___r
dreariest10229123dreariest
drearily1236083drearily
dredger10347453dre_dger
drencher14257213drencher
dresser83611953dre_sser
drier64423963dr___ier
driftier1275123driftier
drippier1385043drippier
droolier936073droolier
droopier1145573droopier
drossier956313drossier
drowsier1284903drowsier
druggier11134833druggier
drumlier1134523drumlier
drummer12407503dr_ummer
dweebier1442223dweebier
dynamiter1542953dynamiter
easier64218463__easier
elmier839813__elmier
flamier123112143_flamier
foamier12339003_foamier
framer114817443fr_am_er
frettier1156593frettier
gamier93617933__gamier
gemmier12337383_gemmier
germier10309543_germier
gleamer10328513gleam_er
grapier103712603gr_apier
grazier173611133gr_azier
greaser83913083grea_ser
greater84416493grea_ter
greedier1036083greedier
greenier938713greenier
gremmie1264383gremmie_
gremmies1355993gremmies
grenadier1144093grenadier
grimier103210433gr_imier
headier113212953_headier
heavier13429423_heavier
leadier83212723_leadier
leafier10329833_leafier
leakier114010993_leakier
learier73415663_learier
leavier10319993_leavier
loamier9349163_loamier
mealier93015903_mealier
meatier93214613_meatier
peakier134411443_peakier
peatier94017233_peatier
preacher153211373preacher
preachier1646923preachier
prealter1048863prealter
preaver121011613prea_ver
preemie11310563preemie_
preemies12512193preemies
premie103617993pre_mie_
premiere12249233pre_miere
premiers122911653pre_miers
premies113823063pre_mies
preppier1156643preppier
prettier1069043prettier
queasier1734473queasier
queazier2642833queazier
racier85120973_r_acier
ramie75027823_r_amie_
ramies84630463_r_amies
rammer103519653_r_ammer
rammier112811023_rammier
rapier84019993_r_apier
reacher123718293_reacher
reader73628293_rea_der
readied93316623_readied
readies83324713_readies
realer63528593_rea_ler
realiser82512563_realiser
realizer172412113_realizer
realter73716313_realter
reamed94326123_ream_ed
reamers94221083_ream_ers
reaming103924013_reaming
reaper84223143_rea_per
rearer64928913_rea_rer
reaver94524733_rea_ver
recamiers1345513_recamiers
reedier83815303_reedier
reefier102912553_reefier
reekier113111123_reekier
rehammer1544653_rehammer
reifier103414523_reifier
relier65826183_re_lier
remaker133813173_remaker
rentier73618223_rentier
replier94214973_replier
revamper1533533_revamper
rheumier1342513rheumier
rimier83916273_r_imier
roamer84715163_roam_er
roomier93812243_roomier
rummier11309563_rummier
screamer12267883scream_er
seamer84223613_seam_er
sleazier1735123sleazier
smearier1036953smearier
sneakier1245143sneakier
steadier937313steadier
steamer93313093steam_er
stemmier1245253stemmier
streakier1334843streakier
streamer10239513stream_er
sweatier1147033sweatier
tearier73815613_tearier
threadier1354473threadier
tramper113812163tr_amper
trampier12318243tr_ampier
treaclier1144153treaclier
treader84113833trea_der
treadler936863treadler
treater74219833trea_ter
treaties8316983treaties
trendier937913trendier
tressier847963tressier
tweakier1533143tweakier
uneasier836963uneasier
unreadier1045013unreadier
vealier102712173_vealier
wearier103613283_wearier
wreaker143610043wrea_ker
wreather14268603wreather

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.406440125.6
2DLD Change Limit1461622326.51622431.2
3Display Results2322320.0932494.6
 (SQL Overall)1786912327.01525472.7
 
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.