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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

69 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
goldeyes134448(None) 
goldeye1234641goldeye_
goldener1045402goldener
goldenest1147872goldenest
goldeneyes1551732goldeneyes
goodbyes15333502goodbyes
boletes9316063bol_etes
cockeyes1967033cockeyes
colleges112410513colleges
deadeyes1344563deadeyes
folders113514393folde_rs
foleys123810463fol_ey_s
galeres83514333gal_eres
galleys11369713galley_s
gelders93812573gelde_rs
gelees74116263gel_e_es
gilders94212463gilde_rs
glebes95512243g_l_ebes
gledes84915133g_l_edes
glees65027593g_l_e_es
gleyed11478153g_l_eyed
gleys96514853g_l_ey_s
goatees82710443goate_es
goddess1035263godde_ss
goddesses1243453goddesses
godets8410933go_de_ts
godless938403godle_ss
goldarns1043593goldarns
goldbugs1342103goldbugs
golden84411153gold__en
goldeneye1452073goldeneye
goldenly1344103goldenly
goldenness1243413goldenness
golder84417603gold__er
goldest92411173golde_st
golds75421313gold___s
goldurns1042603goldurns
golems939323gol_e_ms
golfers114410083golfe_rs
goloshes1236253goloshes
goodbye14364193goodbye_
goodbys14354173goodby_s
goodies93516993good_ies
gooneys11407073gooney_s
guldens9356573gulde_ns
gulleys11438523gulley_s
holders113715903holde_rs
moldered1237173moldered
molders103315553molde_rs
mooneyes1396113mooneyes
oldies7314423_old_ies
oxeyes1635893_o_xeyes
polders103617373polde_rs
poleyns1236113pol_eyns
pollees93215333polle_es
polyenes13510063polyenes
redeyes112910973_redeyes
sockeyes1765763sockeyes
soldered1038153soldered
solderer947183solderer
solderers1066533solderers
solders83517773solde_rs
solfeges1244083solfeges
toluenes836763toluenes
volleyed1543533volleyed
volleyer1443163volleyer
volleyers1542773volleyers
volleys13316643volley_s
walleyes1435603walleyes

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 Filter1786911461620.1531167915.0
2DLD Change Limit146162696.78321548.3
3Display Results69690.0302300.0
 (SQL Overall)178691696.96625651.9
 
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.