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

51 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
preconcerting208441(None) 
preconceiving23102362preconceiving
reconverting1876402_reconverting
concerting15313893___concerting
disconcerting1954573disconcerting
precanceling1952773precance_ling
precancelling2051743precancelling
preconception2154283preconception
preconceptions2253883preconceptions
preconcert16147973preconcert___
preconcerted1953863preconcert_ed
preconcerts17154503preconcert__s
preinserting1544173pre_inserting
preponderating2062583preponderating
reconceiving2093453_reconceiving
reconferring1853723_reconferring
reconnecting1745353_reconnecting
conceiting15311774___conceiting
concerning1548904___concerning
concertina14410614___concertina
concertino14910844___concertino
concreting1539874___concreting
converting16313134___converting
decongesting1753734_decongesting
overconcerning2262424overconcerning
precensoring1753224precensor_ing
precenting151012154pre___centing
precomputing2153274preco_mputing
preconceive2053354preconce__ive
preconizing2548234precon__izing
preconvention2074004preconvention
prelocating1647414prelo_c_ating
preordering15124304pre_order_ing
presorting1339984preso___rting
recollecting1764084_recollecting
reconcentrating2063344_reconcentrating
reconception1855644_reconception
reconceptions1965124_reconceptions
reconciling1645484_reconc_iling
recondensing1653694_recondensing
reconducting1854724_reconducting
reconfirming2053084_reconfirming
reconquering2452994_reconquer_ing
reconsecrating1954194_reconsecrating
reconsulting1554214_reconsulting
recontacting1745064_recontacting
reconvening1746294_reconve_ning
reconveying2044634_reconve_ying
reconvicting20114624_reconvicting
recovering1647374_reco_ver_ing
reinserting1256904_re_inserting

Search took 6 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 Filter178691950240.343520965.0
2DLD Change Limit95024515.14018487.2
3Display Results51510.0331545.5
 (SQL Overall)178691515.51632395.0
 
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.