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

234 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
orgeats83835(None) 
orgeat7515031orgeat_
argents84014852argents
forgets113813792forge_ts
gorgets94711782gorge_ts
greats76318392gr_eats
ordeals877992ordeals
oreads73915772or_eads
organs7912912org_ans
orgiast837462orgiast
orgiasts943802orgiasts
orients7311582orients
outeats72215702outeats
treats64821692tr_eats
agents74816293_agents
areas55935773ar_ea_s
argals75517713arg_als
argent74023663argent_
argots74116033arg_ots
arhats9312973ar_hats
armets84918353arme_ts
arpents93613083arpents
arrears738843arrears
arrests73312683arrests
beats76042243__beats
begets96215523bege_ts
bleats85518613_bleats
boreas85421733bor_ea_s
brats75336013br__ats
breads95419203br_eads
breaks124816423br_eaks
breams104815043br_eams
breast8319633br_east
breasts939703br_easts
breath113916263br_eath
breaths124411183br_eaths
brents84717273br_ents
caveats1239803caveats
cheats114519543_cheats
cleats84919313_cleats
coagents1138453coagents
congeals11309853congeals
congests113510383congests
congrats11311433congrats
corneas94717003cornea_s
cornets94820573corne_ts
corrects1259573corrects
corsets94819803corse_ts
corvets124715023corve_ts
cravats1237403cravats
creaks124315963cr_eaks
creams104715253cr_eams
create85126383cr_eate
creates95225203cr_eates
crests85218703cr_ests
cruets85314953crue_ts
defeats113511233defeats
digests93610613digests
dogears937513dogears
drats66628373dr__ats
dreads84115023dr_eads
dreams94513983dr_eams
drears74614253dr_ears
eats47054873___eats
egests74411253_egests
egrets72712243egre_ts
erects84116183er_ects
ergate7315143erg_ate
ergates8314493erg_ates
ergots74512373erg_ots
feats86432753__feats
forbears1337073forbears
foreguts1245563foreguts
forests104114953for_ests
forfeits1445803forfeits
forgat104018583forg_at_
forgers115218183forge_rs
forges105024263forge__s
forget106326393forge_t_
formats123113573for_mats
frats86829673fr__ats
freaks134713063fr_eaks
frets85523403fr_e_ts
gargets94614573garge_ts
gats56753443__g_ats
gears64628693__gears
gelts65924613__gelts
gents65729613__gents
gests66028813__gests
getas65421483__getas
gets55442483__ge_ts
ghats95818613__ghats
gnats65217713__gnats
goats65527303__goats
gorgeous1046293gorgeous
gorgers94813643gorge_rs
gorges85321893gorge__s
gorget87123863gorge_t_
great66034243gr_eat_
greets75117423gr_eets
groats74816653gr_oats
heats85838403__heats
hoggets12498323hogge_ts
hornets104113553horne_ts
ingests83210983ingests
korats105416063kor__ats
loggats9286453loggats
loggets9378913logge_ts
margents11410133margents
meats75034053__meats
miseats92815783miseats
mordents1138813mordents
morgans10310123morg_ans
morgens10310463morge_ns
neats55931903__neats
nougats8427413noug_ats
oats46554213o___ats
obeahs1135863o_beahs
objects18123693objects
objets15125323obje_ts
obtests9136233obtests
obverts1235403obverts
oceans81211003o_ceans
ocicats11137413ocicats
ocreate93711743ocreate
octets839403octe_ts
offbeats1682813offbeats
ogams84112683o_g_ams
ogees65119143o_ge_es
oghams1245853o_ghams
ogres65818633ogre__s
ogress7529503ogre_ss
oleate6318883o_leate
oleates7417833o_leates
omegas936973omega_s
onsets64013543onse_ts
orals55826483or__als
orate55133303or__ate
orates64328613or__ates
orbits84211443or_bits
orcas75918623or_ca_s
orceins937743orceins
ordeal779253ordea_l
orders74315993orde_rs
oread64619603or_ea_d
oregano846253oregano
oreganos945553oreganos
ores46056683or_e__s
orfrays1343533orfrays
organ6915393org_a_n
organa789213org_ana
orgasm966303org_asm
orgasms1054293orgasms
orgiac934993orgia_c
orgies72316093org_ies
orgones81010793orgones
oriels64914623orie_ls
orient6322533orient_
origans839973origans
orles55326213orle__s
ormers84316143orme_rs
ornate6315143or_nate
orphans1237773orphans
orts46538333or___ts
oughts104710183oug_hts
outeat62824533outeat_
overbeats14279823overbeats
overeats112415263overeats
overheats15229993overheats
owlets93110393owle_ts
oxhearts1842903oxhearts
pageants1136693pageants
pargets105215193parge_ts
peats76140193__peats
pleats85218593_pleats
portents103512823portents
prats76333393pr__ats
preacts113211363pr_eacts
preheats1339413preheats
prests84021263pr_ests
priests93810863priests
rabats83116223_rabats
rats46260373_r__ats
reacts83616603_r_eacts
reads64835273_r_eads
reals55038653_r_eals
reams75729623_r_eams
reaps75626193_r_eaps
rears54739653_r_ears
reata54225393_r_eata
reatas64021013_r_eatas
reests64618893_reests
regears83012463regears
regents83416543regents
reheats104513523reheats
rents55935183_r_ents
repeats94316053repeats
reseats74319583reseats
rests54935873_r_ests
rets45352563_r_e_ts
rheas84816953_rhea_s
rodents8611543rodents
rogers74517913roge_rs
roseate7613453roseate
rosets65819953rose_ts
seats54844343__seats
sergeants10115593sergeants
sorbents10279133sorbents
sorbets93012513sorbe_ts
sweats94814613_sweats
targets84314223targe_ts
teats55636813__teats
threats104311673threats
torments10310453torments
torrents838143torrents
treads74817923tr_eads
treat56240353tr_eat_
treaty94414353tr_eaty
trets55928023tr_e_ts
unseats73012853unseats
upbeats1195733upbeats
ureas55826013ur_ea_s
urgent73816043urgent_
urgers73313623urge_rs
urges64619913urge__s
urtexts1433143urtexts
wergelts1253413wergelts
wheats125013223_wheats
wormgears1541923wormgears
worsets105512843worse_ts
wreaks134711113wr_eaks
wreath124111193wr_eath
wreaths13338373wr_eaths
wrests95313083wr_ests

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.406440125.6
2DLD Change Limit1340272347.00019146.7
3Display Results2342340.0932516.1
 (SQL Overall)1786912347.49923828.6
 
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.