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

58 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
preconcerted195385(None) 
preconceived2252462preconceived
preconcert16147972preconcert__
preconcerts17154502preconcert_s
reconverted1745642_reconverted
concerted14312113___concerted
disconcerted1854343disconcerted
precanceled1852443precance_led
precancelled1951583precancelled
preconceive2053343preconceive_
preconceives2152783preconceives
preconcerting2084403preconcerting
preinserted1443763pre_inserted
preponderated19233403preponderated
reconceived1953773_reconceived
reconferred1783663_reconferred
reconnected1665093_reconnected
conceited14310424___conceited
concerned1438644___concerned
concreted1439414___concreted
converted15311564___converted
decongested1663074_decongested
overconcerned2162524overconcerned
precancer1547084precancer___
precancerous1851964precancerous
precancers1645254precancer__s
precensored1653144precensor_ed
precented14310684pre___cented
precomputed2053364preco_mputed
preconception2154254preconception
preconized2467134precon__ized
preconstructed21102704preconstructed
prelocated1597184prelo_c_ated
preordered1443124pre_order_ed
preponderate17193874preponderate_
preponderates18243674preponderates
presorted1239454preso___rted
recollected1643854_recollected
reconceive1745284_reconceive_
reconceives1864254_reconceives
reconcentrated1983334_reconcentrated
reconciled1545454_reconc_iled
recondensed1543924_recondensed
reconducted1744284_reconducted
reconfirmed1952974_reconfirmed
reconquered2352604_reconquer_ed
reconsecrated1884384_reconsecrated
reconsulted1454234_reconsulted
recontacted1654704_recontacted
reconvened1645394_reconve_ned
reconvert1449474_reconvert__
reconverts1545724_reconvert_s
reconveyed1943474_reconve_yed
reconvicted1944274_reconvicted
recovered15166734_reco_ver_ed
reinserted1146684_re_inserted
unconcerned1653424_unconcerned
unconverted1744774_unconverted

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 Filter1786911247900.1701051123.5
2DLD Change Limit124790589.44013219.3
3Display Results58580.0301933.3
 (SQL Overall)178691589.64018536.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.