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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

74 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
scantlings139331(None) 
scantling12107231scantling_
bantlings12216602_bantlings
catlings113712042_ca_tlings
mantlings12207232_mantlings
sandlings11238092s_andlings
scannings12264822scan_nings
scanting113914762scant_ing_
anglings10228273__anglings
antings85015583__ant_ings
bantling112612003_bantling_
brandlings1443993brandlings
cagelings1335413_cagelings
callings113613833_ca_llings
canaling112016413_canaling_
candling122313873_candling_
cannings113710333_can_nings
cantinas102713783_cant_inas
canting104725903_cant_ing_
carlings114015863_ca_rlings
castings113614053_cast_ings
castling11311233_castling_
catling104819793_ca_tling_
catlins93818843_ca_tlin_s
centrings12227603_centrings
chitlings15255903_chitlings
eanlings9128473_ean_lings
fatlings12359303_fa_tlings
flatlings13315823fla_tlings
gantlines1039333_gantlines
handlings14237343_handlings
mantling112012613_mantling_
panelings12107453_panelings
plantings12348403plant_ings
rattlings10235513_rattlings
sailings93513253s_a_ilings
saltings92811253s_alt_ings
samplings1435553s_amplings
sandling102214413s_andling_
santolinas1043753s_antolinas
saplings11269803s_a_plings
scabbling1634863scabbling_
scaling103519373sca__ling_
scandaling14195453scandaling_
scanning113310773scan_ning_
scanties103215423scant_i_es
scantiness1236883scant_iness
scarting113415263scart_ing_
scathing14269703sca_thing_
scatterings14103973scatterings
scatting113311813sca_tting_
scenting113212813scent_ing_
schillings16243273schillings
schoolings1644013schoolings
scoutings12306143scout_ings
scuttling1234243scuttling_
seatings93614303sea_t_ings
settlings1054683s_ettlings
shaftings16224183shaft_ings
shantungs1341653shant_ungs
shavelings1743503shavelings
skatings13326993ska_t_ings
slanting94115093slant_ing_
slatings94011723sla_t_ings
slattings10346073sla_ttings
spangling1336373spangling_
spankings16215003span_kings
sparlings12257153spa_rlings
stablings12256103sta_blings
standings11257153stan_dings
starlings10237923sta_rlings
startling1037373startling_
weanlings1394413wean_lings
yeanlings1393693yean_lings

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 Filter1786911406030.403443402.0
2DLD Change Limit140603747.47018822.4
3Display Results74740.0461608.7
 (SQL Overall)178691747.91922564.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.