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

70 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
compatriots175354(None) 
compatriot1655961compatriot_
compatriotic2062172compatriotic
compactions1946543compactions
companions1697263compa_nions
comparisons1753973compa_risons
comparts144210833compa_r__ts
compassions1745773compassions
computerists18193913computerists
computists1644693comput_ists
copatrons1346333co_patr_ons
patriots1038053___patriots
chariots1339394c__ha_riots
coaptations1547544coaptations
coatrooms1385414co__atrooms
cockatrices1852334cockatrices
cognations1339594cognat_ions
collations12312854collat_ions
comatiks16148044com_at_i_ks
combatants1653444combat_ants
commotions1686844commot_ions
compaction1846754compactio_n
compactors18256254compa_ctors
compacts16368904compa___cts
compadres16266414compadr__es
companies15311804compa_ni_es
companion1577684compa_nio_n
comparatists1853734comparatists
comparator1665804compa_rator
comparators1785684comparators
comparers15319394compa_r_ers
compares143816434compa_r__es
comparing162410584compa_ri_ng
comparison1644354compa_rison
compart134016004compa_r__t_
comparting17188384comparti_ng
compartments2094334compartments
compassion1645984compassio_n
compatible18125574compat_ible
compatibles19134144compatibles
compatibly21134884compat_ibly
compendious1853374compendious
competitions1845534competitions
competitor1653734compet_itor
competitors1753554competitors
compilations1848684compilat_ions
complaints1646004comp_laints
completions1746914completions
complexions2443624complexions
complots1438164comp___lots
comports143411984comp_or__ts
comprises15510944comp__rises
comprizes2468944comp__rizes
compulsions1744594compulsions
computations1848124computations
computerdoms2161774computerdoms
computerises18224974computerises
computerist17205804computerist_
computerizes27234444computerizes
computist1547324comput_ist_
conations111318904co_nat_ions
connations12312944connat_ions
constricts1477734co_nstricts
cooptions13107764coop_t_ions
coparents1347974co_pa_rents
copatron1246754co_patr_o_n
coralroots1252634co_ralroots
patriot9314534___patriot_
podiatrists1453374podiatrists
sympatries1744684sympatri_es

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 Filter1786911488190.423422437.4
2DLD Change Limit148819708.84316829.0
3Display Results70700.0302333.3
 (SQL Overall)178691709.29619222.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.