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 “compensated” with Change Limit: [1] [2] [3] [4]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

108 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
compensated184486(None) 
compensate1646141compensate_
compensates1745721compensates
commentated1886212commentated
compensator1754672compensator
decompensated21122902decompensated
uncompensated2062742uncompensated
commentate16108173commentate_
commentates17107613commentates
commented16129613commen__ted
compensable1955193compensable
compensating1955003compensating
compensation18126503compensation
compensative2154653compensative
compensators1854373compensators
compensatory2163643compensatory
competed154113593compe___ted
complicated2046093complicated
composited1756003comp_osited
composted16378823comp_os_ted
condensate1345543condensate_
condensates1445313condensates
cooperated1567333coope_rated
decompensate19123643decompensate_
decompensates20113203decompensates
bombinated17154124bombin_ated
camphorated21123584camphorated
catenated1238914c_aten_ated
cemented1338374cem_en__ted
cocreated142710094cocre__ated
coenacted1445804co__enacted
coequated2144824co__equated
comanaged1544524com_an_aged
combated1539824com___bated
combusted1644644com_bus_ted
commemorated1852934commemorated
commenced18157134commen__ced
commended17137014commen__ded
commensal1546024commensa__l
commensally2054794commensally
commensals1645674commensa_ls
commensurate1853024commensurate_
commentator1755274commentator
commenter151410694commen__ter
comminuted17224584commin_uted
communicated2154914communicated
commutated1745424com_mutated
compacted18297364comp__acted
companied1648024compan__ied
companioned1853604companioned
compared153811824comp___ared
comparted16338424comp__arted
compassed1645544comp_as_sed
compeered1646304compe__ered
compelled1646134compe__lled
compend144010304compen____d
compensations19136184compensations
compered153414924compe___red
compete134716554compe___te_
competes144117244compe___tes
complected19295864comp_lected
complemented2154174complemented
completed162810274comp__leted
complicate1847624complicate_
complicates1947054complicates
complotted1743734comp_lotted
comported16319534comp__orted
composed154612064comp_os__ed
composite15410154comp_osite_
composites1648904comp_osites
composter15369574comp_os_ter
compressed1745844compres_sed
comprised1648054compris__ed
compted143813524comp____ted
computed154110954comp___uted
concentrated17116734concentrated
condensed1387114condens__ed
congested1338674conge_s_ted
consecrated1646914consecrated
consented12311944consen__ted
contented12313044conten__ted
contested12310704conte_s_ted
convented15410754conven__ted
cooperate13710144coope_rate_
cooperates1469614coope_rates
copemate1439994co_pe_mate_
copemates1549484co_pe_mates
copulated142710484co_p_ulated
corelated12411824co_re_lated
coronated123313324co_ron_ated
correlated1346684corre_lated
cosponsored1651494cosponsored
covenanted1663804co_venanted
crenated113013914c__ren_ated
dominated1339884dom_in_ated
emendated1344664_em_endated
fomented1437804fom_en__ted
impetrated1544364_impetrated
nominated1239284nom_in_ated
operated11512224_o_pe_rated
orientated1144854_orientated
overcompensated2582764overcompensated
pennated11299544___pennated
pollenated1345014pollen_ated
recompensed18103944recompens__ed
sensated938194___sensated
somerseted1342344som_erseted
tempested1444034tempe_s_ted

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.420425454.8
2DLD Change Limit1488191088.75017007.9
3Display Results1081080.0631714.3
 (SQL Overall)1786911089.23319353.5
 
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.