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

39 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
compromising215292(None) 
comprising1748632compr__ising
uncompromising2391292uncompromising
composing16179843comp_o__sing
compositing1846263comp_ositing
compressing1846433compr_essing
comprizing2647463compr__izing
compromise1854173compromis__e
compromised2052773compromis_ed
compromiser1952623compromis_er
compromisers2051953compromisers
compromises1954183compromis_es
improvising1943843_improvising
outpromising1752423outpromising
promising14410973___promising
unpromising1663623_unpromising
chromizing2746074c__hromizing
colonising1347644co__lonising
commixing2345194com___mixing
communising1844964com_munising
compassing1746554comp__assing
compiling1637764comp___iling
complaining1844734comp_laining
complotting18124264complo_tting
comporting17199164comp_o_rting
composting17178054comp_o_sting
compounding1943074comp_ounding
computerising2062634computerising
coprocessing1953574co_processing
coproducing1953054co_producing
customising1653234c_ustomising
economising1654364eco__nomising
lobotomising1761684lobotomising
nonprossing1454494nonpro_ssing
optimising1544494_o_ptimising
overpromising2153964overpromising
porpoising1545834porp_o_ising
premising14412414___premising
temporising1644964temp_orising

Search took 9 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.376475242.0
2DLD Change Limit124790398.04615509.6
3Display Results39390.0301300.0
 (SQL Overall)178691398.45221141.9
 
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.