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

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

84 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
gelated9361563(None) 
belated103520011belated
delated93722871delated
elated74725821_elated
gelate73421251gelate_
gelates83219581gelates
related83327571related
ablated102513442ablated
aerated85322372aerated
alated75625142_alated
belaced124112152belaced
belayed133610082belayed
belted94020632bel_ted
berated104422132berated
bleated104015972bleated
cerated103922472cerated
chelated142610482chelated
cleated103417842cleated
dealated103213602dealated
debated113916082debated
deflated133412302deflated
delate73827752delate_
delates83526282delates
delayed123310762delayed
deleted93314902deleted
derated93623502derated
dilated93115822dilated
elate55335882_elate_
elater64724202_elater
elates65032362_elates
eluted74915262_eluted
fellated1239562fellated
felted103714652fel_ted
galatea839942galatea
galeated104111572galeated
gated75329772g__ated
geared85317742ge_ared
gelati73814532gelat_i
gelatin83514732gelatin
gelatis83313512gelatis
gelato73812952gelat_o
gelatos83111512gelatos
gelded94512112gel_ded
gelled84718892gel_led
gemmated14336292gemmated
gestated102910572gestated
glared84715192g_lared
glazed174711772g_lazed
gleamed11327932gleamed
gleaned9349422gleaned
gleeted9379322gleeted
gloated93511532gloated
grated84523922g_rated
gyrated12428412gyrated
heated104525592he_ated
lated65240672__lated
legated92513982legated
meated94222402me_ated
melamed1249632melamed
melted94219062mel_ted
negated93413232negated
pelted94617752pel_ted
plated95225772_plated
pleated103816632pleated
rebated103619692rebated
redated93120922redated
reflated123514292reflated
regelated1139722regelated
relaced103517212relaced
relate64033632relate_
relater73723142relater
relates73731422relates
relaxed153312522relaxed
relayed113212752relayed
remated103522472remated
replated112817512replated
reslated93517522reslated
seated75131052se_ated
sedated93714342sedated
slated75028312_slated
solated83618022solated
teated74924022te_ated
velate93720142velate_
welted103715822wel_ted

Search took 4 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 Filter1786911076710.1401276364.3
2DLD Change Limit107671843.20333615.7
3Display Results84840.0332545.5
 (SQL Overall)178691843.37652929.8
 
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.