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

51 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
companioning195293(None) 
campaigning1952003campa_igning
companion1577683companio__n_
companionate1863073companionate
companioned1853603companion_ed
companions1697263companio__ns
companionway2461423companionway
companying2044813compan__ying
complaining1844723complai_ning
cannoning1237324c___annoning
cantoning12310884c___antoning
canyoning1536874c___anyoning
caparisoning1772064c_aparisoning
captioning1545704c_ap_tioning
championing2152734champ__ioning
clarioning1345184c__larioning
comanaging1644324com_an_aging
combining1637894com__bi_ning
commanding1845924comman__ding
commissioning2092624commissioning
communising1844964communi_sing
communizing2745234communi_zing
compacting19177084compa__cting
companionable2162534companionable
companionably2462544companionably
companionship2462114companionship
companionships2571804companionships
companionways2571044companionways
comparing162410584compa___ring
comparting17188374compa__rting
compassing1746544compa__ssing
compassionating2271934compassionating
compensating1955004compensating
compiling1637764comp__i_ling
composing16179844comp___osing
compositing1846264composi_ting
comprising1748634comp_ri_sing
comprizing2647464comp_ri_zing
conditioning1653684conditioning
condoning1339784co___ndoning
containing13410934conta_i_ning
cosponsoring1751624cosponsoring
couponing1446294coup___oning
impassioning1752784_impassioning
occasioning1652514_occasioning
optioning1246554_o_p_tioning
pinioning1246864___pinioning
romanising1346584rom_ani_sing
romanizing2248254rom_ani_zing
womanising1645014wom_ani_sing
womanizing2546104wom_ani_zing

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 Filter1786911247900.1431249587.4
2DLD Change Limit124790516.61018879.0
3Display Results51510.0301700.0
 (SQL Overall)178691516.78326343.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.