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

48 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
compactors1825625(None) 
compacters18247021compacters
compactor17256021compactor_
coactors1239482co__actors
cofactors1645942co_factors
compacter17257882compacter_
compactions1946542compactions
compacts16368902compact__s
comparators1785682comparators
contactors1448842contactors
copastors1346992co_pastors
impactors15265012_impactors
capacitors1643593c_apacitors
coactor1139133co__actor_
cofactor1545763co_factor_
collators11410343colla_tors
collectors1446593collectors
combaters1538113comba_ters
combustors1643753combustors
compact153712213compact___
compacted18297363compact_ed
compactest1845043compactest
compacting19177093compacting
compaction1846753compaction
compactly2043823compact_ly
compactness1953303compactness
companions1697263companions
comparator1665803comparator_
comparers15319393compa_rers
comparts144210833compart__s
competitors1753553competitors
completers16298323completers
compositors1754383compositors
composters16388323composters
compradors1743783compradors
computers15339753comp_uters
concoctors1346403concoctors
conductors1546973conductors
connectors1448183connectors
contactor1348433contactor_
contractors1549163contractors
convectors1768313convectors
copastor1246343co_pastor_
correctors1447493correctors
impacters15305483_impacters
impactor14265013_impactor_
nonactors1147883no_nactors
nonfactors1545333nonfactors

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 Limit140603486.08023125.5
3Display Results48480.0301600.0
 (SQL Overall)178691486.51627423.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.