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

95 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
slanting9411509(None) 
planting113515381planting
scanting113914761scanting
slanging103413431slanging
slating83724651sla_ting
slatting94014231slatting
anting75827022__anting
blanking154411932blanking
blasting114013432blasting
blatting114111652blatting
blunting11319842blunting
canting104725902_canting
chanting143413532chanting
clanging124012122clanging
clanking154313062clanking
elating83423082ela_ting
flanging132710582flanging
flanking164211082flanking
flatting123511252flatting
flaunting1335042flaunting
flinting123412342flinting
glancing1247062glancing
glinting103210052glinting
granting103514522granting
hanting114124482_hanting
islanding1135622islanding
lancing103314122_lancing
landing92819322_landing
lasting84725242_lasting
linting83820982_linting
lunting83817742_lunting
panting104025422_panting
plaiting113113512plaiting
planing103418252plan_ing
planking153513012planking
planning113610222planning
plantings12348402plantings
plating103823072pla_ting
platting114813032platting
quanting1849232quanting
ranting84025412_ranting
sainting93215732sainting
salting84120792s_alting
saluting9310552saluting
sanding93520602s_anding
saning75127642s_an_ing
sating74735452s_a_ting
scanning113310772scanning
scantling12107232scantling
scarting113415262scarting
scatting113311812scatting
scenting113212812scenting
seating84130682sea_ting
shafting15278682shafting
shanking163612282shanking
shantung1232742shantung
shunting123610432shunting
skanking12288742skanking
skating123613852ska_ting
sklenting1475122sklenting
slabbing13287782slabbing
slacking153914132slacking
slagging113711582slagging
slaking123717472sla_king
slamming133310002slamming
slantingly1445152slantingly
slapping133510842slapping
slashing123713412slashing
slatings94011722sla_tings
slattings10346072slattings
slaving113514832sla_ving
slaying113316842sla_ying
sleeting93114162sleeting
slinging103312862slinging
slinking133412982slinking
slitting93012582slitting
slotting92612612slotting
smarting113212452smarting
solating9315592sola_ting
spanking153911972spanking
spanning113311082spanning
spatting113111762spatting
splatting1235982splatting
splinting1238192splinting
standing103413632standing
stanging104013652stanging
staning83922242stan_ing
starting93116172starting
stating83725162sta_ting
stinting93415742stinting
stunting92811502stunting
swanking16399962swanking
swanning12338812swanning
swatting12309592swatting
wanting114220172_wanting

Search took 5 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 Filter1786911210590.390458182.1
2DLD Change Limit121059953.90630993.1
3Display Results95950.0303166.7
 (SQL Overall)178691954.32641306.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.