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

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

49 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
noncooperations1963171noncooperations_
noncooperation1863702noncooperation__
noncooperators1862423noncooperat_ors_
cooperations1659194___cooperations_
noncooperative21113474noncooperati__ve
noncooperator1762794noncooperat_o__r
noncorrelations17122824noncorrelations_
nonoperational1663764non__operational
conglomerations2062735conglomerations_
cooperation15410025___cooperation__
cooperationist1864225___cooperationist
incorporations18134855_incorporations_
noncelebrations19122825noncelebrations_
noncompetition2062875noncompetition__
nonconnections1894145nonconne_ctions_
nonconservation2063095nonconservation__
noncorrelation16113085noncorrelation__
nonoperating1555415non__operati_n_g
concatenations1873726conc_atenations_
concelebrations21103166concelebrations_
concentrations1877076conc_entrations_
confederations20104606con_federations_
conglomeration1963006conglomeration__
considerations1764846con_siderations_
conspirations1747726con__spirations_
cooperating1648426___cooperati_n_g
cooperationists1963196___cooperationists
cooperatives1965556___cooperatives_
cooperators1547006___cooperat_ors_
corporations16129486___corporations_
incarcerations1853006_incarcerations_
incinerations1545686_inc_inerations_
incorporation17115616_incorporation__
noncelebration18113316noncelebration__
noncompetitors2071996noncompe__titors_
nonconnection1784416nonconne_ction__
nonconsumptions2182276nonconsumptions_
nonconventional20102586nonconve_ntional
noncultivations20182756noncultivations_
nonimportations1962106nonimportations_
nonoperatic1565796non__operati___c
nonoperative1756286non__operati__ve
nonsegregations17162696nonsegregations_
operations12312956_____operations_
recuperations1746086_rec_uperations_
reoperations14410066___reoperations_
syncopations1952886sync_op__ations_
uncooperative2083106_uncooperati__ve
vociferations2153116vo_c_iferations_

Search took 5 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 Filter178691658740.0931921408.6
2DLD Change Limit65874494.37615053.5
3Display Results49490.0461065.2
 (SQL Overall)178691494.51539577.2
 
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.