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

94 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
glimpses134395(None) 
glimpse1233761glimpse_
glimpsed1442771glimpsed
glimpser1342661glimpser
glimpsers1442191glimpsers
glimes94717522glim__es
guimpes1245072guimp_es
limpsey14365092_limpsey
aliases7914493ali_ases
animuses1037983animuses
blimps12588153blimp__s
blisses94911513bli_sses
climates12311963climates
climaxes1944613climaxes
climes104720003clim__es
crimples14308963crimples
dimples122813213_dimples
eclipses1244213ecli_pses
elapses957663el_apses
ellipses1044343ellipses
flimsies1335783flimsies
gimmes113010903g_im_mes
gimmies123010103g_immies
gimped123911473g_imp_ed
gimpier12247933g_impier
gimpiest1338473g_impiest
gimps105915203g_imp__s
gipsies1039903g_i_psies
glacises1138503glacises
glasses84414273gl_asses
glibness1134133glibness
glides84518863gli__des
glime85620193glim__e_
glimed105312283glim__ed
glimmer12437713glim_mer
glimmers13396153glimmers
glimpsing1542593glimpsing
glims87417673glim___s
glitches14296653glitches
glitzes17367563gli_tzes
glosses84014123gl_osses
glucoses1145333glucoses
glumes94516813glum__es
glumness1135203glumness
glumpier1334873glumpier
glumpiest1434943glumpiest
grampuses1442973grampuses
grilses8319153gri_lses
grimaces1355383grimaces
grimes94619033grim__es
grimness1175993grimness
gripes94619873gri_p_es
grippes124810373gri_ppes
guimpe1134723guimp_e_
guises74216313gui__ses
gummoses1344743gummoses
imposes113213683__imposes
lampases1267293_lampases
lapses85217693_l_apses
liaises7311053_liaises
ligases82310703_ligases
limbuses1234903_limbuses
limes75636503_lim__es
limites92915453_limites
limpas105513083_limp_as
limped114817123_limp_ed
limper104117853_limp_er
limpers113815223_limpers
limpest113712313_limpest
limpet103518633_limp_et
limpets11329783_limpets
limpness1246703_limpness
limps95522673_limp__s
limpsier1234433_limpsier
limpsiest1344793_limpsiest
limpsy13516843_limps_y
lipases9209483_lipases
litmuses1044463_litmuses
mimeses1139073_mimeses
palimpsest16201913palimpsest
phimoses1537193phimoses
pimples133012423_pimples
plisses94411773pli_sses
primuses1237083primuses
reimposes1345473reimposes
rimples113114223_rimples
simples113014943_simples
slimes84722043slim__es
slimness1036523slimness
slimpsier1343023slimpsier
slimpsiest1443033slimpsiest
slimpsy1463333slimps_y
slipes84921413sli_p_es
wimples143311173_wimples

Search took 10 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.220812231.8
2DLD Change Limit146162949.14015991.5
3Display Results94940.0462043.5
 (SQL Overall)178691949.40618997.6
 
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.