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

74 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
companied164802(None) 
companies15311801companies
accompanied2052272accompanied
commanded17136502commanded
compacted18297362compacted
companion1577682companion
companioned1853602companioned
compared153811822compa_red
comparted16338422comparted
compassed1645542compassed
complained17175792complained
complied1539672comp_lied
accompanies1953373accompanies
campanile1544403campanile
campaniles1644113campaniles
campanili1553003campanili
comanaged1544523com_anaged
combated1539823comba_ted
combatted1644653combatted
combined15269183combin_ed
command14399213comman__d
commander16127403commander
commenced18157133commenced
commended17137013commended
commented16129613commented
communed15338213commun_ed
communised1744953communised
communized2645283communized
compacter17257883compacter
compadre15295883compadre_
compadres16266413compadres
companions1697263companions
company1619711143compan__y
companying2044813companying
compare135814993compa_re_
comparer143611363compa_rer
compares143816433compa_res
comparing162410583comparing
compasses1547393compasses
comped135919873comp___ed
compeered1646303compeered
compelled1646133compelled
compend144010303compen__d
compered153414923comp_ered
competed154113593comp_eted
compiled1537813comp_iled
complainer1645693complainer
completed162810263completed
complexed23295973complexed
complier14310253comp_lier
complies14314523comp_lies
compline14313553compline_
complines15312833complines
compone136517193compon_e_
comported16319533comported
composed154612063comp_osed
composited1756003composited
composted16378813composted
compounded1843083compounded
comprised1648053comprised
comprized2567223comprized
compted143813523comp__ted
computed154110953comp_uted
contained12310893contained
copied114618563co_p__ied
covaried1448003co_varied
oompahed1642903oompa_hed
romanced1337253rom_anced
romanised1247923rom_anised
romanized2149213rom_anized
tympanies1644263tympanies
womaned1337213wom_an_ed
womanised1545753wom_anised
womanized2447043wom_anized

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 Filter1786911486410.1561145455.1
2DLD Change Limit148641746.62322443.2
3Display Results74740.0302466.7
 (SQL Overall)178691746.80926243.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.