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

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
limned9481147(None) 
limbed114513181limbed
limed85426801lim_ed
limner84112871limner
limped114817121limped
lined64934641li_ned
aimed85626052aim_ed
aliened81011742aliened
aligned9128552aligned
alined75221402ali_ned
binned94414542binned
climbed14336982climbed
damned104212912damned
dimmed124110322dimmed
dined76431992di_ned
dinned84317612dinned
fined94930502fi_ned
finned104114602finned
gimped123911472gimped
ginned83813982ginned
girned84010512girned
glimed105312282glim_ed
hymned1535322hymned
imbed105013652_imbed
imped105117982_imped
inned64118422_inned
kilned11368392kilned
kirned11408622kirned
lambed115614782lambed
lamed85235292lam_ed
lammed113915622lammed
lamped114017542lamped
leaned73422542leaned
liane54720662liane_
lianes63819322lianes
licked134621562licked
lidded93410242lidded
lied55838092li__ed
lifted104413522lifted
liked104523812li_ked
likened12267352likened
lilied73913212lilied
lilted73715372lilted
limber104316792limber
lime66244932lim_e_
limen75426032lim_en
limens84618032limens
limes75636502lim_es
limey104721042lim_ey
limier83518722limier
limited102310232limited
limmer104314792limmer
limn66527692limn__
limners93311562limners
limnic10418842limnic
limns75718392limn_s
limper104117852limper
limpet103518632limpet
limpid11389752limpid
line46965572li_ne_
linen55728722li_nen
liner55938922li_ner
lines57054572li_nes
liney87029632li_ney
linked114518212linked
linnet6419422linnet
linted74021822linted
lipped114419542lipped
lisped94113422lisped
listed74322832listed
lived95523722li_ved
livened11238932livened
loaned73816292loaned
lumped114216962lumped
mimed105622732mim_ed
mined85333352mi_ned
nimmed11368572nimmed
pimped134913482pimped
pined85935322pi_ned
pinned94818382pinned
rimed84826372rim_ed
rimmed114812302rimmed
signed83413752signed
simnel857022simnel
sinned73818412sinned
slimed94915122slim_ed
slimmed12368472slimmed
timed85223612tim_ed
tined65434532ti_ned
tinned74317532tinned
vined95626152vi_ned
wimped144211512wimped
wined94434182wi_ned
winned104017012winned

Search took 3 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.360496363.9
2DLD Change Limit82551942.26636430.3
3Display Results94940.0303133.3
 (SQL Overall)178691942.65667278.2
 
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.