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

136 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
glimpse123376(None) 
glimpsed1442771glimpsed
glimpser1342661glimpser
glimpses1343951glimpses
blimps12588152blimps_
gimps105915202g_imps_
glime85620192glim__e
glimes94717522glimes_
glimpsers1442192glimpsers
glims87417672glim_s_
guimpe1134722guimp_e
guimpes1245072guimpes
limps95522672_limps_
limpsey14365092_limpsey
limpsy13516842_limpsy
slimpsy1463332slimpsy
blimp115612943blimp__
blimpish1743723blimpish
blips95615783bli_ps_
chimps155713663chimps_
clamps124515083clamps_
climate11312833climate
climbs12498723climbs_
clime95720893clim__e
climes104720003climes_
clips96018303cli_ps_
clomps125212233clomps_
clumps1215314643clumps_
crimple13408693crimple
crimps124613453crimps_
dimple113512793_dimple
eclipse1144183ecli_pse
eglomise1143933eglomise
elapse857523el_apse
ellipse944013ellipse
flimsy14345563flim_sy
flips105117743fli_ps_
flumps135112503flumps_
gamps105323713g_amps_
gimme102411343g_im_me
gimmes113010903g_immes
gimmie11298183g_immie
gimp96124043g_imp__
gimped123911473g_imped
gimpier12247943g_impier
gimpy135212233g_imp_y
gips75632923g_i_ps_
gipsy11579543g_i_psy
glams85822933glam_s_
glias64618493gli_as_
glide74521593gli__de
glides84518863glides_
gliffs13436323gliffs_
glim76026353glim___
glimed105312283glim_ed
gliming113310133gliming
glimmer12437713glimmer
glimpsing1542593glimpsing
glints75714213glints_
gliomas1035333gliomas_
glitzes17367563glitzes
globose1035543globose
gloms85219783glom_s_
glomus9468093glomus_
glops85619553gl_ops_
glucose1045113glucose
glume85120463glum__e
glumes94516813glumes_
glumpier1334873glumpier
glumpy14527193glump_y
glums84621423glum_s_
gramps114114273gramps_
grilse7399503gri_lse
grimace1255083grimace
grime85021323grim__e
grimes94619033grimes_
gripe84622963gri_p_e
gripes94619873gri_pes
grippe115310323gri_ppe
grippes124810373grippes
gripple12416613gripple
grips85520133gri_ps_
grumose1035723grumose
grumps114510573grumps_
guise64717713gui__se
gummose1235333gummose
impose103113053__impose
imps86221123__imps_
lamps95624833_lamps_
lapse74917683_l_apse
liaise6310693_liaise
ligase7259913_ligase
limas75627633_limas_
limbs96118943_limbs_
lime66244933_lim__e
limes75636503_limes_
limns75718393_limns_
limos75320813_limos_
limp88432493_limp__
limpa97014463_limp_a
limpas105513083_limpas
limped114817123_limped
limper104117853_limper
limpest113712313_limpest
limpet103518633_limpet
limpid11389753_limpid
limply133810033_limply
limpsier1234433_limpsier
lipase8239103_lipase
lipe66839733_li_p_e
lips67141443_li_ps_
lisps76913913_lisps_
lumps95624983_lumps_
pimple123512963_pimple
pimps114616983_pimps_
plisse8368403pli_sse
plumose1135963plumose
plumps124612613plumps_
primps124711823primps_
reimpose1245623reimpose
rimose8310593_rimose
rimple103814583_rimple
simple104315173_simple
simps94719763_simps_
skimps14488043skimps_
slime74925753slim__e
slimes84722043slimes_
slimpsier1343023slimpsier
slims75423653slim_s_
slimsy11407723slim_sy
slipe75626133sli_p_e
slipes84921413sli_pes
slips76023723sli_ps_
slumps104313583slumps_
wimple133611363_wimple
wimps125213803_wimps_

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271365.67323625.4
3Display Results1361360.0462956.5
 (SQL Overall)1786911366.12529174.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.