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

308 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
orgeat751503(None) 
orgeats838351orgeats
argent74023662argent
forgat104018582forg_at
forget106326392forge_t
gorget87123862gorge_t
great66034242gr_eat
ordeal779252ordeal
oread64619602or_ead
organ6915392org_an
orgiac934992orgiac
orgiast837462orgiast
orient6322532orient
outeat62824532outeat
treat56240352tr_eat
urgent73816042urgent
agent65829643_agent
ardent73022613ardent
area45843403ar_ea_
areae55229753ar_eae
areal55928743ar_eal
areas55935793ar_eas
argal65023403arg_al
argents84014853argents
argot67728653arg_ot
arhat8327103ar_hat
armet76739463arme_t
arpent84822093arpent
arrear6310253arrear
arrest63722633arrest
beat66168303__beat
begat86629723beg_at
beget85632563bege_t
bleat75737003_bleat
boreal84817213bor_eal
boreas85421743bor_eas
brat66055543br__at
bread85523113br_ead
break115319403br_eak
bream95121813br_eam
breast8319643br_east
breath113916273br_eath
brent75734133br_ent
caveat11417723caveat
cheat105732453_cheat
cleat76335063_cleat
coagent10313983coagent
cogent9321003cogent
congeal104011683congeal
congest104618773congest
cornea84018933cornea_
corneal94414503corneal
corneas94717003corneas
cornet84436733corne_t
correct11513983correct
corset85636223corse_t
corvet114626933corve_t
cravat11314443cravat
creak115418433cr_eak
cream95721353cr_eam
create85126383cr_eate
crept95125893cr_ept
crest74632693cr_est
cruet74831843crue_t
defeat103817163defeat
digest84019623digest
dogear838193dogear
drat56247833dr__at
dread74419023dr_ead
dream85120393dr_eam
dreamt94615713dr_eamt
drear65016903dr_ear
drest65530343dr_est
driest74722753driest
dryest104811123dryest
eat36989053___eat
egest65222343_egest
egret63327313egre_t
erect74129333er_ect
ergate7315143erg_ate
ergot65422893erg_ot
feat76458223__feat
forbear1237523forbear
foregut1149163foregut
forest94926743for_est
forfeit1339203forfeit
forge95126943forge__
forged115519323forge_d
forger104820773forge_r
forgers115218183forgers
forgery14419303forgery
forges105024263forge_s
forgets113813793forgets
forgot104318133forg_ot
format113021363for_mat
fornent10312933fornent
forwent13310533forwent
frat75648543fr__at
freak125115243fr_eak
freest95318283freest
fret75845043fr_e_t
garget84327273garge_t
gat46880513__g_at
gear55934973__gear
gelt56448013__gelt
gent56954393__gent
gest56149133__gest
get47467463__ge_t
geta56627443__geta
ghat86435283__ghat
gnat56034433__gnat
goat56250833__goat
gorge76423893gorge__
gorged95016983gorge_d
gorger86116983gorge_r
gorgers94813643gorgers
gorges85321893gorge_s
gorgets94711783gorgets
goriest82218743goriest
grat55651283__grat
greats76318403gr_eats
greet65835323gr_eet
groat65531973gr_oat
heat77061423__heat
hereat93527413hereat
hogget114715763hogge_t
hornet94926433horne_t
horrent10313553horrent
hugest10311763hugest
ingest73119003ingest
irreal657833irreal
korat94934443kor__at
largest83715103largest
longest84114953longest
loreal63814313lor_eal
margent10316693margent
meat66359603__meat
miseat82925713miseat
morceau1145573morceau
mordent10313993mordent
morgan9311373morg_an
morgen9312203morge_n
morgens10310463morgens
neat46356783__neat
nonmeat9312773nonmeat
nougat74712653noug_at
oat39888263o___at
obeah1038993o_beah
object17135803object
objet141213143obje_t
obtect10129633obtect
obtest81213013obtest
obvert11412993obvert
ocean71212963o_cean
ocicat101412813ocicat
ocrea73311823ocrea_
ocreae83310273ocreae
ocreate93711743ocreate
octet7324063octe_t
oddest81710863oddest
odea56224573o_dea_
offbeat1564143offbeat
oftest91212003oftest
ogam75120033o_g_am
ogee57629883o_ge_e
ogees65119143o_gees
ogham1138253o_gham
ogre56320743ogre__
ogres65818633ogre_s
ogress7529503ogress
oldest72114093oldest
olea46532723o_lea_
oleate6318883o_leate
omega836383omega_
omegas936983omegas
oncet74626543once_t
onset54730173onse_t
oogeny10117923oogeny
ora37250833or__a_
orad56031693or__ad
oral47638123or__al
orate55133303or__ate
orbed85516193orbe_d
orbiest9312413orbiest
orbit73622063or_bit
orca65522773or_ca_
orcas75918623or_cas
orcein838183orcein
ordeals878003ordeals
order65019363orde_r
orders74315993orders
ore36661833or_e__
oreads73915773or_eads
oregano846253oregano
ores46056683or_e_s
orfray1234393orfray
organa789213organa
organs7912913organs
orgasm966303orgasm
orgiasts943803orgiasts
orgic8311823org_ic
orgies72316093orgies
orgone71110913orgone
orgy85218003org__y
oriel54920423orie_l
oriels64914623oriels
orients7311583orients
origan7310693origan
orle45630463orle__
orles55326213orle_s
ormer75218373orme_r
ormers84316143ormers
ornate6315143or_nate
ornery938463ornery
orogeny11107023orogeny
orphan1137733orphan
orra46120723or_ra_
orrery936783orrery
ort39465233or___t
osteal6312963osteal
ought95221543oug_ht
outeats72215703outeats
outsat62920283outsat
overbeat132713833overbeat
overeat102620323overeat
overgreat1347713overgreat
overheat142413773overheat
overneat112713643overneat
overt85630723o_vert
owlet83324463owle_t
oxheart1746213oxheart
pageant10312783pageant
parget94529393parge_t
peat65967933__peat
pleat74734473_pleat
porrect1159743porrect
portent93619643portent
prat65952043pr__at
preact103220393pr_eact
preheat12413893preheat
prest75736353pr_est
priest84125423priest
rabat72832223_rabat
rat37892743_r__at
react74634333_r_eact
read55942533_r_ead
real45750293_r_eal
ream65841613_r_eam
reap65934743_r_eap
rear45644553_r_ear
reata54225393_r_eata
reest54938093_reest
reft75141273_r_eft
regal65023793_regal
regear73512743regear
regent74127673regent
reheat94423943reheat
rent46661243_r_ent
repeat85127213repeat
resat55139683_resat
reseat64131493reseat
rest46459843_r_est
ret35982833_r_e_t
rhea75017433_rhea_
rheas84816953_rheas
rodent7519243rodent
roger64521413roge_r
rogers74517913rogers
roseate7613453roseate
roset55945243rose_t
sagest74920263sagest
seat47575563__seat
sergeant9129403sergeant
sorbent92915243sorbent
sorbet83924083sorbe_t
sorest65028003sor_est
sweat85628403_sweat
target75028913targe_t
teat45963633__teat
threat95020463threat
torment9316173torment
torrent7313413torrent
tread64821703tr_ead
treats64821703tr_eats
treaty94414353tr_eaty
tret46653533tr_e_t
truest64816193truest
turgent8712393turgent
unseat64221023unseat
upbeat10911513upbeat
urea46528063ur_ea_
ureal56722683ur_eal
ureas55826013ur_eas
urge54722423urge__
urged75316033urge_d
urger64116473urge_r
urgers73313623urgers
urges64619913urge_s
urtext1337433urtext
wergelt1138583wergelt
wheat114924573_wheat
wormgear1441883wormgear
worset96726583worse_t
wreak125513273wr_eak
wreath124111193wr_eath
wrest84925433wr_est
wriest94419713wriest
wryest12429113wryest

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 Filter1786911127160.796224486.2
2DLD Change Limit1127163086.70316815.8
3Display Results3083080.0933311.8
 (SQL Overall)1786913087.59223536.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.