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 “ghees” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

161 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
ghees9521555(None) 
gees55647881g_ees
ghee85726111ghee_
glees65027591glees
grees65132471grees
agrees74915322agrees
akees96119242akees
bees65453382_bees
brees75632552brees
cees65941592_cees
cheek145115712cheek
cheeks154712782cheeks
cheep125416502cheep
cheeps135312912cheeps
cheer105420382cheer
cheers114518912cheers
cheese113812762cheese
cheesy14419192cheesy
chefs136214662chefs
chess105016922chess
chews135418512chews
dees56356632_dees
drees65628522drees
epees75219832epees
fees76450602_fees
flees85828752flees
frees86131392frees
gaes56348032g_aes
gages74529972gages
gales65442482gales
games86238552games
gapes86030822gapes
gases65633992gases
gates65939502gates
gazes155425912gazes
geds66730812g_eds
gee45359202g_ee_
geed65435502g_eed
geek95327022g_eek
geeks104915842geeks
geese64316002g_eese
geest64829612g_eest
geez146424862g_eez
gelees74116262gelees
gels56836102g_els
gems75329112g_ems
genes65133092genes
gens55740072g_ens
gets55442482g_ets
ghats95818612ghats
ghis85020162gh_is
gibes84422522gibes
gies55641422g_ies
gites65630182gites
gives95324872gives
glebes95512242glebes
gledes84915132gledes
gleds75417892gleds
glee55239062glee_
gleed75320572gleed
gleeds84711622gleeds
gleek105315102gleek
gleeks11489672gleeks
gleet65532342gleet
gleets75315052gleets
glens66519852glens
gleys96514852gleys
glues65125682glues
goers65520252goers
goes55644092g_oes
gores65740372gores
goxes135018262goxes
grebes93813612grebes
gree56641562gree_
greed75125692greed
greeds84314282greeds
greek105915942greek
green65522142green
greens75716872greens
greet65835322greet
greets75117422greets
greys96614852greys
grues65721962grues
gudes74520812gudes
guess64213362guess
gules64831042gules
gybes115012722gybes
gyres94820322gyres
gyves125711552gyves
haes77651022_haes
hebes105521672_hebes
heed86437602_heed
heeds95420422_heeds
heel75034222_heel
heels85625532_heels
hehs106723962_hehs
hemes105031082_hemes
hems95534942_hems
hens75642572_hens
heres86245902_heres
hers75844872_hers
hes66654202_h_es
hets75547202_hets
hews105631572_hews
hexes155123042_hexes
hies74842832_hies
hoes75755732_hoes
hues75235232_hues
jees115938542_jees
khets124913432khets
knees95114872knees
lees45455882_lees
ogees65119142ogees
pees65257372_pees
prees75937172prees
rees45364192_rees
rheas84816952rheas
rhemes115913182rhemes
sees45361052_sees
sheas86331792sheas
sheds96122702sheds
sheen85023312sheen
sheens95116992sheens
sheep105321522sheep
sheer84726892sheer
sheers94322402sheers
sheesh1237812sheesh
sheet84836952sheet
sheets93918492sheets
shes75734352sh_es
shews115924712shews
shies86136552shies
shoes85429652shoes
skees95023122skees
tees45353582_tees
thebes115914492thebes
thee78039062thee_
themes115319252themes
thens85921832thens
theres96525472theres
these86519012these
theses96517972theses
thews117416192thews
threes97117322threes
trees55835762trees
tyees86019452tyees
vees75439432_vees
wees76249122_wees
whee105429592whee_
wheel115515332wheel
wheels123811712wheels
wheen115016052wheen
wheens124610612wheens
wheep136214352wheep
wheeps14439952wheeps
whens114618762whens
wheres125917432wheres
whets115019612whets
whews145114492whews
wheys145911552wheys
zees136331892_zees

Search took 3 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 Filter178691538000.0802233637.5
2DLD Change Limit538001611.87328724.0
3Display Results1611610.0463500.0
 (SQL Overall)1786911611.99989390.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.