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

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

86 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
controversies186334(None) 
controversial1862652controversial
controversy1952583controvers__y
controverted1852903controver_ted
controverter1752793controver_ter
controverters1852463controverters
controverting1953363controverting
controverts1654263controver__ts
centromeres1553884centromer__es
conniveries1644704con_niver_ies
containerises1553164containerises
contraries12711934contr__ar_ies
contravenes1655634contrave__nes
contrivers1547254contriver___s
controllerships22132024controllerships
controversially2381494controversially
controvert1547174controver___t
controvertible21101834controvertible
converses14311164con___vers_es
introversion1554084_introversion
introversions1663694_introversions
introversive1863214_introversive
uncontroversial20101004uncontroversial
centromere1453775centromer__e_
centromeric1753245centromer_i_c
comraderies1653975co_mrader_ies
concourses1445355con_co_urs_es
confreres1448035confr__er__es
congeries12316405con___ger_ies
conglomerates1862945conglomerates
congresses1348025congr__e_sses
congruencies1753235congr_uencies
containerise1453975containerise_
containerised1662215containerised
containerizes2462725containerizes
containerships2163055containerships
contingencies1853525contingencies
contrabasses1652295contr_abasses
contraceptives2362145contraceptives
contrarieties1563815contrarieties
contravene1545095contrave__ne_
contravened1753555contrave__ned
contravener1653425contrave__ner
contraveners1753505contrave_ners
contravening1853565contrave_ning
contravention18103875contravention
contraventions19103575contraventions
contredanses1552885contredans_es
contritenesses1655495contritenesses
contrivances1954135contriv_ances
contriver1448345contriver____
contrives14311705contriv____es
controllers1344785controller___s
controllership21182205controllership
contumelies1563275cont_ume_lies
converges1538385con___ver_ges
converse13310265con___vers_e_
conversed1538685con___vers_ed
converser1438095con___vers_er
conversers1547355con___versers
conversing16310545con___versing
conversion1548425con___version
conversions1648275con___versions
conversos1446895con___vers_os
cookeries151210635co___oker_ies
cooperies131113315co___oper_ies
coronaries12410235co__ronar_ies
costumeries1554105cost_umer_ies
coteries10422705co_t___er_ies
counterspies1648315count___erspies
countersues1348535count___ersues
courtesies1246455co_ur_te_sies
coversines15128635c____oversines
extroversion2282285_extroversion
extroversions2382155_extroversions
introversively2371955_introversively
introverted1553485_introver_ted
introverting1654275_introverting
introverts1344585_introver__ts
noncoverages1862775non_coverages
ontogenies1147075_ont_oge_nies
poltrooneries1561465poltrooner_ies
retroversion1573675_retroversion
retroversions1673455_retroversions
traverses1246345___travers_es
untraversed1553085_untravers_ed

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.390458182.1
2DLD Change Limit124790869.42313243.1
3Display Results86860.0461869.6
 (SQL Overall)178691869.85918124.7
 
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.