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

214 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
driegh1125456(None) 
dreigh11246441dreigh
dreg66821652dr_eg_
dregs76114862dr_egs
dreich12377722dreich
dried75321382drie_d
drier64423962drie_r
driers74516732driers
dries64733672drie_s
driest74722752driest
ariel55228973arie_l
ariels65119373ariels
aright103817663ari_ght
aweigh1334933aweigh
breech13348263breech
bridge103711883bridge
brie65837903brie__
brief105422603brie_f
briefs115510073briefs
brier74527403brie_r
briers85319733briers
briery114510773briery
bries74942153brie_s
brig76528033bri_g_
bright124215923bri_ght
brigs85823223bri_gs
bring85528503bring_
brings94618433brings
brith104924373bri_th
brugh115414293br_ugh
creesh11328333creesh
cried84624293crie_d
crier74724463crie_r
criers83918583criers
cries75438403crie_s
cringe93515483cringe
daledh1133743daledh
daleth1038633daleth
daring84928683daring_
darings93713653darings
deign74312803dei_gn
die46759663d_ie__
died66137863d_ie_d
diel59034613d_ie_l
diene65720133d_iene
dies55653533d_ie_s
diet57357543d_ie_t
diets66026643d_iets
dig57544483d_i_g_
dight104027003d_i_ght
digs66036063d_i_gs
ding66940963d_ing_
dinge75627303d_inge
dinghy14476963d_inghy
dingo74720793d_ingo
dings76331403d_ings
dingy105721263d_ingy
dire56644153dire__
direct93817333direct
direly10311563direly
direr64927073dire_r
direst75024243direst
dirge75117073d_irge
dirges84915103dirges
dish86328343d_i_sh
ditch115015093d_itch
doeth9411983d_oeth
doing74923583doing_
doings84913183doings
dories75232363dorie_s
dough105217383d_ough
drag64825053dr_ag_
dragee84415603dragee
draggy12346823draggy
drags75521113dr_ags
draught12266983draught
dread74419023dr_ead
dream85120393dr_eam
drear65016903dr_ear
dreck124812803dr_eck
dredge9308563dredge
dree56638323dr_e_e
dreed75222843dr_eed
drees65628523dr_ees
dreggy12364633dreggy
dreidl835233dreidl
drek96321093dr_e_k
dreks105714753dr_eks
drench12369593drench
dress65319833dr_ess
drest65530343dr_est
drew86221673dr_e_w
drib76823263dri__b
dribs85115063dri_bs
drift95722843dri_ft
drifts10499893drifts
drifty13418223drifty
drill64718263dri_ll
drills74414203drills
drily95816523dri_ly
drink106816383dri_nk
drinks116810713drinks
drip76223953dri__p
drippy14445653drippy
drips85417233dri_ps
dript86923873dri_pt
drive95318003dri_ve
drivel105110383drivel
drivels11397923drivels
driven105210143driven
driver104714493driver
drivers114412793drivers
drives105117113drives
drongo836793drongo
drought12258883drought
drouth104410103drouth
drudge9317903drudge
drug65718133dr_ug_
druggy12344743druggy
drugs75214653dr_ugs
dryer95111463drye_r
dryers10449273dryers
dryest104811123dryest
drying113411603drying_
dryish1336323dryish
during84419403during_
dying105316033dying_
dyings11478133dyings
eringo739553eringo
freight1447603freight
fresh115012203fr_esh
fridge11379253fridge
fried95322913frie_d
friend10388933friend
frier85225843frie_r
friers94718933friers
fries85535603frie_s
frieze18378143frieze
frig85424503fri_g_
friges104116483friges
fright133715243fri_ght
frigs96019273fri_gs
fringe104013953fringe
fringy13309263fringy
frith115922033fri_th
grego7310523gr_ego
greige847203greige
grief95319783grie_f
griefs10418723griefs
grieve1047243grieve
grig65424773gri_g_
grigs75318193gri_gs
grinch1238483grinch
gringa838553gringa
gringo838643gringo
grith95520373gri_th
heigh124812543hei_gh
high116619933_hi_gh
iring66025423iring_
laigh95515923lai_gh
liege65314433_liege
neigh94912383nei_gh
nigh85220673_ni_gh
oriel54920423orie_l
oriels64914623oriels
orient6322533orient
pried84426863prie_d
prier75027763prie_r
priers84521193priers
pries74339533prie_s
priest84125423priest
prig75924873pri_g_
prigs85219703pri_gs
reg46146493_r_eg_
regs55436573_r_egs
reign65015193_reign
resh76523453_r_esh
rich97025553_ri_ch
ridge75018683_ridge
ridgy104110653_ridgy
riel46432393_rie_l
riels55121333_riels
rig46748133_ri_g_
right94430503_ri_ght
rigs55137603_ri_gs
ring56541163_ring_
rings65029173_rings
rough97819443_rough
siege66718443_siege
sigh85625903_si_gh
skeigh14265903skeigh
skreegh15182643skreegh
skreigh15243703skreigh
sleigh10258203sleigh
thigh12410123thi_gh
triage72812893triage
tried65026913trie_d
triene64316383triene
triens65417543triens
trier54328533trie_r
triers64321523triers
tries55742813trie_s
trig55528163tri_g_
trigo65716053tri_go
trigs65423063tri_gs
trough108512033trough
weigh125412513wei_gh
wried95518563wrie_d
wrier84521753wrie_r
wries85827743wrie_s
wriest94419713wriest
wright133713513wri_ght
wring95920713wring_
wrings104012973wrings

Search took 7 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.373479064.3
2DLD Change Limit1127162145.84619280.9
3Display Results2142140.0603566.7
 (SQL Overall)1786912146.27928458.5
 
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.