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

105 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
limpers11381522(None) 
lampers113817331lampers
limbers113614741limbers
limmers113413081limmers
limners93311561limners
limper104117851limper_
limpets11329781limpets
lippers113416441lippers
lispers94514321lispers
lumpers113514481lumpers
simpers113014121simpers
aimers84621912aim_ers
bumpers133912052bumpers
campers134220292campers
clampers143211892clampers
climbers14318412climbers
clippers14368842clippers
crimpers14318932crimpers
dampers123915692dampers
diapers104713912diapers
dimers94321092dim_ers
dimmers123811562dimmers
dippers123615182dippers
dumpers123412662dumpers
flippers15338002flippers
gippers123212082gippers
glimmers13396152glimmers
glimpsers1442192glimpsers
hampers143616952hampers
humpers142713522humpers
impels10389522_impels
jimper17389862jimper_
jumpers18399842jumpers
kippers153211432kippers
lambers113817112lambers
lappers113717462lappers
leapers93716662leapers
lepers84817322l_epers
libbers113812832libbers
libers84721442li_bers
lickers134118252lickers
liers55130402li__ers
lifers95617842li_fers
lifters104313782lifters
ligers75022042li_gers
likers104620912li_kers
limber104316792limber_
limens84618032lim_ens
limes75636502lim_e_s
limeys11429272lim_eys
limier83518722limier_
limiters10249332limiters
limmer104314792limmer_
limner84112872limner_
limpas105513082limp_as
limped114817122limpe_d
limpest113712312limpest
limpet103518632limpe_t
limpness1246702limpness
limps95522672limp__s
liners65428852li_ners
lingers84223302lingers
linkers114317712linkers
linters73822632linters
lippens11328532lippens
lipper104219632lipper_
lisper84114432lisper_
listers74026532listers
liters65429882li_ters
litters73422572litters
livers94927822li_vers
liviers104211072liviers
livyers13365902livyers
loopers93914032loopers
lopers84424142l_opers
loppers113014102loppers
lumbers113815912lumbers
lumpens11298262lumpens
lumper103816652lumper_
mimers105520182mim_ers
mumpers133311372mumpers
nippers113012622nippers
pampers133615932pampers
pipers104318662pi_pers
plumpers14357292plumpers
pumpers133113672pumpers
rimers84522552rim_ers
rimmers113812882rimmers
rippers114115032rippers
rompers113412242rompers
simmers113314612simmers
simper103616292simper_
sippers113117752sippers
slimmers12369632slimmers
slippers123711232slippers
tampers113516742tampers
tempers113513012tempers
timbers113111852timbers
timers84420992tim_ers
tippers113414352tippers
vampers143111622vampers
vipers114914532vi_pers
whimpers18276612whimpers
wipers115416082wi_pers
zippers203310382zippers

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.360496363.9
2DLD Change Limit1076711053.17033965.6
3Display Results1051050.0333181.8
 (SQL Overall)1786911053.56350151.8
 
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.