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

90 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
compensating195500(None) 
commentating1957042commentating
compensation18126502compensation
compensations19136182compensations
compensative2154652compensative
decompensating2262522decompensating
commenting1749173commen__ting
compensate1646143compensat__e
compensated1844863compensat_ed
compensates1745723compensat_es
compensational2073523compensational
compensator1754673compensat_or
compensators1854373compensators
compensatory2163643compensatory
competing163712463compe___ting
complicating2145633complicating
compositing1846263comp_ositing
composting17178053comp_os_ting
cooperating1648423coope_rating
bombinating1844434bombin_ating
camphorating2252564camphorating
catenating1348684c_aten_ating
cementing1438764cem_en__ting
cocreating15310294cocre__ating
coenacting1545874co__enacting
coequating2245324co__equating
comanaging1644324com_an_aging
combating16310164com___bating
combusting1745454com_bus_ting
commemorating1953074commemorating
commencing1946184commen__cing
commendation1946514commendation
commendations2055804commendations
commending1846634commen__ding
commensalism1764954commensalism
comminuting1844504commin_uting
communicating2254874communicating
commutating1846024com_mutating
compacting19177094comp__acting
companioning1952934companioning
companying2044814compan__ying
comparing162410584comp___aring
comparting17188384comp__arting
compassing1746554comp_as_sing
compeering1747054compe__ering
compellation1855104compellation
compellations1954814compellations
compelling1746554compe__lling
compensable1955194compensa_ble
compering163414164compe___ring
complecting2045764comp_lecting
complementing2253614complementing
completing1748424comp__leting
complotting18124264comp_lotting
comporting17199164comp__orting
composing16179844comp_os__ing
compressing1846434compres_sing
comprising1748634compris__ing
compting153013604comp____ting
computing16309854comp___uting
concentrating1856434concentrating
condensation1546784condensation
condensations1646274condensations
condensing1447744condens__ing
congesting14410114conge_s_ting
consecrating1747944consecrating
consenting13313224consen__ting
contenting13313324conten__ting
contesting13312214conte_s_ting
conventing16311544conven__ting
copulating1549374co_p_ulating
corelating13511584co_re_lating
coronating13410174co_ron_ating
correlating1487084corre_lating
cosponsoring1751624cosponsoring
covenanting1743014co_venanting
decompensation2193364decompensation
decompensations22103044decompensations
dominating1449404dom_in_ating
emendating1444614_em_endating
fomenting1537234fom_en__ting
impetrating1644644_impetrating
nominating1349504nom_in_ating
operating12313724_o_pe_rating
orientating1245774_orientating
pollenating1444554pollen_ating
recompensing1953864recompens__ing
sensating1039254___sensating
somerseting1453064som_erseting
tempesting1544454tempe_s_ting

Search took 8 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.390458182.1
2DLD Change Limit124790907.29617103.9
3Display Results90900.0631428.6
 (SQL Overall)178691907.74923059.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.