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

47 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
preconceives215279(None) 
preconceive2053351preconceive_
preconceived2252471preconceived
reconceives1864261_reconceives
reconceive1745292_reconceive_
reconceived1953782_reconceived
conceives1639233___conceives
misconceives2162823misconceives
preconceiving23102363preconceiving
preconcerted1953863preconcerted
preconcerts17154503preconce_rts
preconizes2358193precon__izes
reconciles1447063_reconc_iles
conceive1539234___conceive_
conceived1746714___conceived
conceiver1657414___conceiver
conceivers1746314___conceivers
misconceive2063164misconceive_
misconceived2272444misconceived
misconceiver2172064misconceiver
misconceivers2271414misconceivers
perceives1646314p_e__rceives
precanceled1852454precance_led
precancelled1951594precancelled
precancels1644064precance__ls
precancerous1851964precancerous
precancers1645254precance__rs
precocious1644744preco_c_ious
precocities1748164preco_cities
precognitive2052754precognitive_
preconceptions2253884preconceptions
preconcert16147974preconce__rt
preconize2268634precon__ize_
preconized2467144precon__ized
preconscious1852904preconscious
prerogatives1853434prerogatives
preventives1945724preven_tives
receives1339744_re___ceives
recencies13312254_recenc_i_es
reconceiving2093454_reconceiving
reconcile1347844_reconc_ile_
reconciled1545464_reconc_iled
reconciler1444694_reconc_iler
reconcilers1543424_reconc_ilers
recondenses1444964_recondenses
reconfines1546654_recon_fines
reconvenes1546504_reconve_nes

Search took 9 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.406440125.6
2DLD Change Limit124790478.07615452.0
3Display Results47470.0331424.2
 (SQL Overall)178691478.51520985.4
 
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.