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

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
cooperates146961(None) 
cooperages1565581cooperages
cooperate13710141cooperate_
cooperated1567331cooperated
cooperage1465262cooperage_
cooperatives1965552cooperatives
cooperator1446832cooperator
cooperators1547002cooperators
cooperies131113322cooper_ies
copemates1549482c_opemates
copperases1644892copperases
corporates14410732corporates
operates10515412__operates
reoperates1249662reoperates
asperates11312553_asperates
biopirates1474163biopirates
cerates95428253c___erates
coacervates1883593coacervates
cocreates132611883cocre_ates
compensates1745723compensates
comperes143217973comper__es
competes144117243compe__tes
conepates13912283c_onepates
consecrates1548393consecrates
cookeries151210643cooker_ies
cooperating1648423cooperating
cooperation15410023cooperation
cooperations1659193cooperations
cooperative1847053cooperative
coopered133310943cooper__ed
coopers114019483cooper___s
copemate1439993c_opemate_
copperahs18323893coppera_hs
copperas14308573coppera__s
copperplates1752223copperplates
copulates132612463c_opulates
corelates11314863c_orelates
corporate13410903corporate_
correlates1248673correlates
coverages1538833c_overages
exonerates17107343exonerates
moderates12710753_moderates
operate9615733__operate_
operated11512223__operated
reoperate11410183reoperate_
reoperated1348153reoperated
tolerates9312123_tolerates

Search took 7 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 Filter1786911406030.406440125.6
2DLD Change Limit140603476.50021631.2
3Display Results47470.0301566.7
 (SQL Overall)178691476.93625762.8
 
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.