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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

118 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
lapses8521769(None) 
apses76823911_apses
elapses957661elapses
lapises93513461lapises
lapse74917681lapse_
lapsed94712581lapsed
lapser84113141lapser
lapsers93911051lapsers
lapsus8437271lapsus
lases54944761la_ses
lasses64827591lasses
apes66047432_ap_es
apres75426402_apres
apse67725382_apse_
apsis75718292_apsis
arses55733872_arses
asses55629282_asses
baases85218012baases
bases75644352ba_ses
basses85428302basses
capes95441922cap_es
carses85233652carses
cases75048382ca_ses
causes88026472causes
classes94717942classes
clauses93813322clauses
copses104922472copses
daises74318982daises
eases56041612ea_ses
elapse857522elapse_
elapsed1056102elapsed
gapes86030822gap_es
gases65633992ga_ses
gasses75724782gasses
glasses84414272glasses
hanses95022632hanses
hawses125113992hawses
japes146322822jap_es
laces76141762la_ces
laches116528352laches
lades65141272la_des
ladies75124882ladies
ladles74619542ladles
lakes95737652la_kes
lames75445542la_mes
lampases1267292lampases
lances84824102lances
lanes54946792la_nes
lapel73716682lap_el
lapels83712042lapels
lapides103012042lapides
lapins84520682lapins
lapis76223152lap_is
lapped114320032lapped
lapper104319952lapper
lappers113717462lappers
lappet103817732lappet
lappets11329132lappets
laps66848872lap__s
larees65323112larees
lares54852632la_res
larges74824232larges
lase46148512la_se_
lased65132342la_sed
laser54633322la_ser
lasers64925702la_sers
lashes94831002lashes
lass47444542la_s_s
lassies74420102lassies
lassis65216702lassis
lassoes74613852lassoes
lassos64913812lassos
lasts57731262la_sts
lathes95127502lathes
latkes104715872latkes
lattes65324202lattes
laves86039152la_ves
laxes125430092la_xes
lazes145129572la_zes
lazies154418782lazies
leases65428112leases
lenses64620892lenses
leses54930812l_eses
liaises7311052liaises
lipases9209482lipases
looses67328252looses
lopes76437342lop_es
loses56742012l_oses
losses65925232losses
louses66230282louses
lupuses936272lupuses
lyases95211872lyases
lyses84518252l_yses
manses84225512manses
maples104819422maples
marses84827112marses
masses85028712masses
napes74828462nap_es
nappes104515622nappes
oases55330982oa_ses
parses85534702parses
pases75346502pa_ses
passes86030472passes
pauses84621472pauses
raises64826542raises
rapes75740722rap_es
raphes115117452raphes
rases55447212ra_ses
relapses1038032relapses
sasses64124392sasses
sepses84515882sepses
tapes75838602tap_es
tapises92914012tapises
tasses64826762tasses
tawses94913192tawses
upases84112902upases
valses94514612valses
vases84626262va_ses

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 Filter178691825510.343520965.0
2DLD Change Limit825511182.64331233.8
3Display Results1181180.0303933.3
 (SQL Overall)1786911183.01659247.7
 
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.