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

147 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
limpsey1436509(None) 
limpsy13516841limps_y
glimpse1233762glimpse_
glimpsed1442772glimpsed
glimpser1342662glimpser
glimpses1343952glimpses
lamprey1434862lamprey
limey104721042lim__ey
limped114817122limp_ed
limper104117852limp_er
limpest113712312limpest
limpet103518632limp_et
limply133810032limp_ly
limps95522672limps__
limpsier1234432limpsier
linsey938992li_nsey
slimpsy1463332slimps_y
biopsy1334533biops_y
blimey13468453blim__ey
blimps12588153blimps__
dimple113512793dimple_
dimpled132810303dimpled
dimples122813213dimples
dimply14339743dimp_ly
flimsy14345563flim_s_y
gimped123911473gimp_ed
gimpier12247943gimpier
gimps105915203gimps__
gimpy135212233gimp__y
gipsy11579543gi_ps_y
glimpsers1442193glimpsers
imped105117983_imp_ed
impel95711773_imp_el
imphee13310353_imphee
impiety1445093_impiety
impled113812513_impled
imply124911843_imp_ly
impose103113053_impose_
imposed123110293_imposed
imposer113310103_imposer
imposes113213683_imposes
imps86221123_imps__
jimper17389863jimp_er
jimpest18297553jimpest
jimply20397483jimp_ly
jimpy195210823jimp__y
lamasery1343953lamasery
lampases1267293lampases
lamped114017543lamp_ed
lampreys1542883lampreys
lamps95624833lamps__
lapse74917683l_apse_
lapsed94712583l_apsed
lapser84113143l_apser
lapses85217693l_apses
liaise6310693liaise_
liaised837113liaised
liaises7311053liaises
ligase7259913ligase_
ligases82310713ligases
limas75627633limas__
limbed114513183lim_bed
limber104316793lim_ber
limbier11349113limbier
limbs96118943limbs__
limbuses1234903limbuses
limby125714073lim__by
lime66244933lim__e_
limed85426803lim__ed
limen75426033lim__en
limes75636503lim__es
limeys11429273lim__eys
limier83518723lim_ier
limiest93716103limiest
limited102310233limited
limiter92710853limiter
limites92915453limites
limmer104314793lim_mer
limned94811473lim_ned
limner84112873lim_ner
limns75718393limns__
limos75320813limos__
limp88432493limp___
limpa97014463limp__a
limpas105513083limp_as
limpers113815223limpers
limpets11329783limpets
limpid11389753limp_id
limpidly1643153limpidly
limping124614113limping
limpkin1534223limpkin
limpness1246703limpness
limpsiest1344803limpsiest
limy95727713lim___y
liney87029633li__ney
linseys1035083li_nseys
lipase8239103lipase_
lipases9209483lipases
lipe66839733li_p_e_
lipped114419543li_pped
lippen103911403li_ppen
lipper104219633li_pper
lippier112710573lippier
lippy124511903li_p_py
lips67141443li_ps__
lisped94113423lisp_ed
lisper84114433lisp_er
lisps76913913lisps__
litmuses1044463litmuses
lumped114216963lump_ed
lumpen104010663lump_en
lumper103816653lump_er
lumpier113410143lumpier
lumpily1476563lumpily
lumps95624983lumps__
lumpy126615913lump__y
mimeses1139073mimeses
mosey105922873__mosey
pimped134913483pimp_ed
pimple123512963pimple_
pimpled14289193pimpled
pimples133012423pimples
pimply15329213pimp_ly
pimps114616983pimps__
rimose8310593rimose_
rimosely1343943rimosely
rimple103814583rimple_
rimpled123311423rimpled
rimples113114223rimples
simper103616293simp_er
simple104315173simple_
simpler112910863simpler
simples113014943simples
simplex18256393simplex
simply133010523simp_ly
simps94719763simps__
slimpsier1343023slimpsier
slimsy11407723slim_s_y
tipsy106010503ti_ps_y
whimsey18373893whim_sey
wimped144211513wimp_ed
wimpier14248053wimpier
wimple133611363wimple_
wimpled15338823wimpled
wimples143311173wimples
wimps125213803wimps__
wimpy155911923wimp__y

Search took 8 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.390458182.1
2DLD Change Limit1340271476.56320421.6
3Display Results1471470.0463195.7
 (SQL Overall)1786911476.99925530.9
 
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.