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

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

80 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
linecasters1310259(None) 
linecaster1282911linecaster_
cineastes1165563cine_aste_s
forecasters1675003forecasters
limewaters1543523limewa_ters
linebackers1952333linebackers
linecasting14102783linecasting
linecastings1551553linecastings
pinasters1136823pin__asters
ringmasters14132803ringmasters
telecasters1343783telecasters
bandmasters1684184bandmasters
bimesters1336344bime__sters
casters94729904____casters
cineaste1045744cine_aste__
cineasts1045544cine_ast__s
cinemagoers1651954cinemagoers
criticasters1651694criticasters
decanters12229224__decanters
diasters92913184di___asters
diesters92513604di_e__sters
digesters11257884dige__sters
disasters1039154di__sasters
easters75125684___e_asters
feasters11511564__fe_asters
figeaters1345754fige_a_ters
firewaters1644324firewa_ters
forecaster1586004forecaster_
incases93615974_in_cas_e_s
incenters112510304_in_centers
inciters103210674_in_c_iters
infecters14257584_infec__ters
infesters12237714_in_festers
inflaters1247544_infla_ters
insisters997654_in_sisters
kiesters123310154ki_e__sters
lasters75627694l____asters
leasers74717844l__e_as_ers
leisters83312824l__e_isters
levanters1254994l__evanters
liberates111012944libera_te_s
liberators1247014libera_tors
licensers11114584lice_ns_ers
lifecares1463814lifeca_re_s
lifesavers1651764lifesa_vers
limewater1444074limewa_ter_
lineages979184line_a_ge_s
lineate7815154line_a_te__
lineated9711064line_a_te_d
linebacker1852774linebacker_
linecuts1094554linec_ut__s
linters73822634lin____ters
listers74026534li____sters
literates91415654litera_te_s
literators1048104litera_tors
loadmasters1453314loadmasters
locaters102710074l__oca_ters
minelayers1543454minela_yers
ministers1139624min__isters
minsters103813924min___sters
negaters9349784__nega_ters
nesters74422794__ne__sters
newscasters1651604newscasters
oleasters936734_ole_asters
piasters102912814pi___asters
pilasters1138224pi__lasters
pinaster1037114pin__aster_
poetasters1245284_poetasters
recanters112310484__recanters
remasters11310584__remasters
rimesters1137484rime__sters
ringmaster13142984ringmaster_
shinplasters1751864shinplasters
slicksters1643384sli__cksters
telecaster1244214telecaster_
tidewaters1443464tidewa_ters
webcasters1742144_webcasters
wildcatters1751434wildcatters
winemakers1944284winema_kers
zincates1937744zin_ca_te_s

Search took 10 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 Filter1786911488190.420425454.8
2DLD Change Limit148819809.03316475.0
3Display Results80800.0461739.1
 (SQL Overall)178691809.49918811.6
 
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.