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

448 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
grieve104724(None) 
grieved1235281grieved
griever1136031griever
grieves1137321grieves
aggrieve13102042aggrieve
breve105317052br_eve
drive95318002dri_ve
frieze18378142frieze
give85829352g_i_ve
grave94624872gr_ave
greave104611492greave
grebe85114942gr_ebe
gree56641562gr_e_e
greige847202greige
gride75223582gri_de
grief95319772grie_f
griefs10418722griefs
grievers1255472grievers
griffe13438092griffe
grille74315742grille
grilse7399502grilse
grime85021322gri_me
gripe84622962gri_pe
grippe115310322grippe
grivet103517822grivet
groove10438872groove
grove95219332gr_ove
lieve86315472_lieve
nieve85613182_nieve
reeve84121322_reeve
reive85522942_reive
riever94811652_riever
rive75537722_ri_ve
scrieve12448332scrieve
shrieve13417682shrieve
sieve84918842_sieve
slieve9359272slieve
thieve1235962thieve
triene64316382triene
achieve1545023achieve
aggrieved1591373aggrieved
aggrieves14101903aggrieves
agree65226033agr_e_e
alive85722513ali_ve
apiece10510083apiece
areae55229743ar_eae
arene55329413ar_ene
arete56031353ar_ete
ariel55228973arie_l
ariels65119373ariels
ariette7312373ariette
ariose64818723ariose
arise56436433ari_se
arrive91311793arrive
believe12519773believe
bireme10310143bireme
brave104925503br_ave
brede85520503br_ede
bree67241263br_e_e
breeze17298963breeze
breves115516423br_eves
brevet115717333br_evet
bribe94820773bri_be
bribee104316363bribee
bride86425533bri_de
bridge103711883bridge
bridle94115463bridle
brie65837903bri__e
brief105422593brie_f
briefed1335743briefed
briefer1235563briefer
briefs115510073briefs
brier74527403brie_r
briers85319733briers
briery114510773briery
bries74942153brie_s
brine75132273bri_ne
chive135117623chi_ve
crave105626313cr_ave
creese84014333creese
creme94319323cr_eme
crepe95520723cr_epe
cried84624283crie_d
crier74724463crie_r
criers83918583criers
cries75438403crie_s
crime94822693cri_me
cringe93515483cringe
cripe95521143cri_pe
derive103817043deri_ve
diene65720133_diene
dive85634773_di_ve
drave95219273dr_ave
dree56638323dr_e_e
dried75321383drie_d
driegh11254563driegh
drier64423963drie_r
driers74516733driers
dries64733673drie_s
driest74722753driest
drivel105110383drivel
driven105210143driven
driver104714493driver
drives105117113drives
drove95518063dr_ove
eve66331163___eve
five107629743_fi_ve
free75940183fr_e_e
freeze18349513freeze
frere85617723fr_ere
fridge11379253fridge
fried95322913frie_d
friend10388933friend
frier85225843frie_r
friers94718933friers
fries85535603frie_s
friezes19418913friezes
fringe104013953fringe
frise85322453fri_se
frisee94217993frisee
gaiety10119373gaiety
galeae74717453galeae
galere73716673galere
gamete9313593gamete
ganev95513863ganev_
ganevs10456913ganevs
garigue935583garigue
gave84634053g__ave
gee45359203g__e_e
geese64316003g_eese
gelee63626983gele_e
gene56237223g__ene
geneva1085853geneva
ghee85726113g_he_e
gibe75927773g_i_be
gie47149543g_i__e
gied64631983g_ie_d
gien56330023g_ie_n
gies55641423g_ie_s
gighe10139733g_ighe
gigue71210673g_igue
gimme102411343g_imme
girdle82110463girdle
girlie73711463girlie
gite55438613g_i_te
given95915283g_iven
giver94921203g_iver
gives95324873g_ives
glaive10357933glaive
glebe85016443g_lebe
glede75517833g_lede
glee55239063g_le_e
glide74521593gli_de
glime85620193gli_me
glove94516293g_love
goitre7349003goitre
gorier73719373gorie_r
goriest82218743goriest
grace85124543gr_ace
grade75126093gr_ade
gramme114210333gramme
grange83716203grange
grape84824663gr_ape
grate64932883gr_ate
graved114818813graved
gravel105313823gravel
graven104513523graven
graver105018593graver
graves104624003graves
gravy125512113gr_avy
graze155820053gr_aze
grease75416233grease
great66034243gr_eat
greaved12408913greaved
greaves113311443greaves
grebes93813613gr_ebes
greed75125693gr_eed
greeds84314283greeds
greedy11518843greedy
greek105915943gr_eek
green65522143gr_een
greened93111263greened
greener83111713greener
greenie8310123greenie
greens75716873greens
greeny104811453greeny
grees65132473gr_ees
greet65835323gr_eet
greeted93111383greeted
greeter82812673greeter
greets75117423greets
grego7310523gr_ego
greiges937733greiges
greisen856503greisen
grew85620263gr_e_w
grey85624043gr_e_y
greyed114610603gr_eyed
greyer104510093gr_eyer
greys96614853gr_eys
gribble12297273gribble
grid65829613gri__d
gridded11387583gridded
gridder10367763gridder
griddle1035503griddle
grided95117043grided
grides84422363grides
grids75321393gri_ds
grievance1542953grievance
grievant1244803grievant
grieving1385893grieving
grievous1243583grievous
griff124416453gri_ff
griffes14367923griffes
griffs13398993griffs
grift95924463gri_ft
grifted12379583grifted
grifter113810493grifter
grifts104511683grifts
grig65424773gri__g
grigri833853grigri
grigs75318193gri_gs
grill64617893gri_ll
grilled94012833grilled
griller84513353griller
grilles83715023grilles
grills74314803grills
grilses8319153grilses
grim76929423gri__m
grimace1255083grimace
grimed104714093grimed
grimes94619033grimes
grimier103210433grimier
grimly12459933grimly
grimmer123510093grimmer
grimy114312603gri_my
grin55733723gri__n
grinch1238473grinch
grind75917563gri_nd
grinded104210633grinded
grinder93312393grinder
grinds84511843grinds
gringa838543gringa
gringo838643gringo
grinned9378553grinned
grinner8329233grinner
grins65427223gri_ns
griot65328413gri_ot
griots74713643griots
grip76127023gri__p
griped104114713griped
griper94114613griper
gripers104011463gripers
gripes94619873gripes
gripey124111203gripey
gripier103210323gripier
gripmen1235033gripmen
gripped13419343gripped
gripper124410713gripper
grippes124810373grippes
gripple12416613gripple
grippy14447763grippy
grips85520133gri_ps
gript85126173gri_pt
gripy115115253gri_py
grisette994653grisette
grisly104310583grisly
grison7310103grison
grist65529873gri_st
grister83915413grister
gristle8169223gristle
grists74716483grists
grit55247243gri__t
grith95520373gri_th
griths105211653griths
grits65529583gri_ts
gritted94110903gritted
gritter83913353gritter
gritty10338403gritty
grivets11357973grivets
grizzle16306113grizzle
grooved12347253grooved
groover11358543groover
grooves11368803grooves
groovy13375403groovy
grope84821613gr_ope
grosze16457733grosze
grouse74315023grouse
groved114413703groved
grovel104310543grovel
groves104318103groves
groyne1037213groyne
grudge9388583grudge
grue55825713gr__ue
gruel66014743grue_l
grueled937133grueled
grueler837023grueler
gruels73910153gruels
grues65721963grue_s
grume86218163gr_ume
grunge8359583grunge
gruyere1133123gruyere
guide75019883gui_de
guile64521133gui_le
guimpe1134723guimpe
guise64717713gui_se
gwine95513663gwi_ne
gyrene10227243gyrene
gyve116215083g__yve
hiree85427803hire_e
hive106029673_hi_ve
jive146123593_ji_ve
keeve124512123_keeve
krewe1238193kr_ewe
liege65314433_liege
liever94611863_liever
live76540993_li_ve
naive85116213nai_ve
neve76224833__neve
niece74814503_niece
nieves94311293_nieves
ogive9379093ogi_ve
olive84817153oli_ve
oreide7311673oreide
oriel54920423orie_l
oriels64914623oriels
orient6322533orient
oriole6814293oriole
pareve114613013pareve
peeve104915253_peeve
piece96717993_piece
pree67044733pr_e_e
prese75228383pr_ese
prevue1179163pr_evue
price93725413pri_ce
pride84724733pri_de
pried84426863prie_d
prier75027763prie_r
priers84521193priers
pries74339533prie_s
priest84125423priest
prime96525603pri_me
prince104114763prince
prise74632613pri_se
prisere9310943prisere
privet113821343privet
privy13439833pri_vy
prize164718943pri_ze
prove104823193pr_ove
rave75542093_r_ave
reave84528023_reave
rede55037663_r_ede
ree37974073_r_e_e
reeved104118713_reeved
reeves94721493_reeves
reived104518133_reived
reiver95318293_reiver
reives95723043_reives
releve95116403releve
relieve105010693relieve
reprieve1375443reprieve
rete44944133_r_ete
retrieve1175693retrieve
rev65336623_r_ev_
revel84423163_r_evel
revet84938843_r_evet
revs75027053_r_evs
revue81114453_r_evue
rheme106214053_rheme
rice64942913_ri_ce
ride55945123_ri_de
ridge75018663_ridge
riel46432383_rie_l
riels55121333_riels
rievers104311453_rievers
rife74632323_ri_fe
rifle85518333_rifle
rile45650533_ri_le
rille55728733_rille
rime65138883_ri_me
rinse54820973_rinse
ripe66038923_ri_pe
rise45945233_ri_se
rite45849453_ri_te
rived94825613_rived
riven85121623_riven
river85731693_river
rives85336003_rives
rivet85636363_rivet
rove75136983_r_ove
scrieved14366203scrieved
scrieves13387613scrieves
scrive115414943scri_ve
sheeve123412843sheeve
shive114423423shi_ve
shrieved15276073shrieved
shrieves14297093shrieves
shrive125216953shri_ve
siege66718443_siege
sieved104611443_sieved
sieves93216003_sieves
siree55238813sire_e
skive124614113ski_ve
sleeve93411593sleeve
slieves10378963slieves
steeve93710903steeve
strive95020963stri_ve
swive115316193swi_ve
thieved1434973thieved
thieves1346903thieves
thrive125313223thri_ve
trave85223033tr_ave
tree47745813tr_e_e
trevet94818913tr_evet
triage72812893triage
tribe74420263tri_be
trice75127493tri_ce
tried65026913trie_d
trienes74118413trienes
triens65417543triens
trier54328533trie_r
triers64321523triers
tries55742813trie_s
trifle94012883trifle
trike95320163tri_ke
trine54734603tri_ne
triode75311893triode
triose64715383triose
tripe75425383tri_pe
triple84215923triple
trireme935263trireme
triseme936543triseme
triste63818643triste
trite54730033tri_te
triune64210183triune
trivet93721883trivet
trove85221923tr_ove
unreeve10176763unreeve
ureide7310363ureide
urine55026593uri_ne
vive105426623_vi_ve
waive114214603wai_ve
wive105931753_wi_ve
wried95518563wrie_d
wrier84521753wrie_r
wries85827743wrie_s
wriest94419713wriest
write85522833wri_te
writhe125310703writhe

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.1401276364.3
2DLD Change Limit1127164487.19015676.8
3Display Results4484480.1403200.0
 (SQL Overall)1786914487.47023921.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.