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

54 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
compromiser195262(None) 
compromise1854171compromise_
compromised2052771compromised
compromisers2051951compromisers
compromises1954181compromises
composer145012953comp_o__ser
comprise14310813compr__ise_
comprised1648053compr__ised
comprises15510943compr__ises
compromising2152923compromising
copromoter1644573co_promoter
improviser1773313_improviser
promiser122510673___promiser
chromier1538034c__hromi_er
comonomer1545024comonom__er
compiler1438374comp___iler
complainer1645694comp_lainer
complier14310254comp__li_er
compose135716664comp_o__se_
composed154612064comp_o__sed
composers153910644comp_o__sers
composes145017124comp_o__ses
composite15410154comp_osite_
composited1756004comp_osited
composites1648904comp_osites
compositor1644634comp_ositor
composter15369574comp_o_ster
compounder1743434comp_ounder
compressed1745844compr_essed
compresses1647774compr_esses
compressor1644354compr_essor
comprisal1544514compr__isal
comprize2368734compr__ize_
comprized2567224compr__ized
comprizes2468944compr__izes
comptroller1751734comptro_ller
coproducer1763074co_producer
coprolite1348624co_prolite_
coprolites1448224co_prolites
copromoters1753994co_promoters
improvise1674854_improvise_
improvised1873574_improvised
improvisers1892774_improvisers
improvises1784594_improvises
improvisor1782764_improvisor
outpromise1442664outpromise_
outpromised1651984outpromised
outpromises1552254outpromises
promise113415844___promise_
promised133010884___promised
promisee122711334___promisee
promisers13268204___promisers
promises122916764___promises
promisor12266184___promisor

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.436409841.7
2DLD Change Limit148819548.59317318.6
3Display Results54540.0331636.4
 (SQL Overall)178691549.06219718.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.