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

157 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
complicated204609(None) 
complicate1847621complicate_
complicates1947051complicates
complected19295862complec_ted
complicatedly2561702complicatedly
implicated1745972_implicated
uncomplicated2253762uncomplicated
colligated1446273co_lligated
collimated1556083co_llimated
collocated1546163co_llocated
colocated1439613co__located
communicated2154903communicated
compacted18297363comp_ac_ted
compensated1844863compensated
completed162810263compl__eted
complicacies1962793complicacies
complicacy2052783complica_cy
complicating2145623complicating
complication2048193complication
complice1639333complic__e_
complices1739253complic__es
complicit1747433complicit__
complicities2055953complicities
complicity2145693complicit_y
complied1539673compli___ed
complimented2153363complimented
complotted1743733compl_otted
conflicted1844053conflic_ted
duplicated1655833_duplicated
explicated22106103_explicated
implicate1547273_implicate_
implicates1646783_implicates
noncomplicated2362613noncomplicated
plicated13310643___plicated
replicated1548773_replicated
supplicated1843733supplicated
triplicated1653933triplicated
auspicated1544304ausp_icated
bombinated17154124bom_binated
camphorated21123584camphorated
capitated14159044c_ap_itated
captivated1844764c_aptivated
ciliated11510954c__ili_ated
cocultivated2052254cocultivated
cogitated1346324co__gitated
colicweed1742154co__licweed
collated113615064co__l_lated
collected1447964co_llec_ted
colligate1248294co_lligate_
colligates1347714co_lligates
collimate1348164co_llimate_
collimates1447974co_llimates
collocate1348664co_llocate_
collocates1448124co_llocates
colocate12313434co__locate_
colocates13312854co__locates
combated1539824com___bated
commentated1886214commentated
comminuted17224584com_minuted
committed1645724com_mi_tted
communicate1956174communicate_
communicatee2055074communicatee
communicates2055604communicates
commutated1745424com_mutated
compacter17257884comp_ac_ter
compared153811824comp___ared
comparted16338424comp__arted
compensate1646144compensate_
compensates1745724compensates
competed154113594comp___eted
compiled1537814comp_i__led
complained17175794compl_ained
compleat14710154compl_eat__
complect1659014complec_t__
complects1766414complec_t_s
complemented2154174complemented
complete143412054compl__ete_
completer153310414compl__eter
completes153212924compl__etes
complexed23295974compl__exed
compliance1844934compli_ance
compliances1945034compliances
compliancy2153754compli_ancy
compliant1549664compli_a_nt
compliantly2053834compliantly
complicatedness24102074complicatedness
complications2147424complications
complicitous2052394complicitous
complier14310254compli___er
complies14314524compli___es
compline14313554compli__ne_
complines15312834compli__nes
comported16319534comp__orted
composited1756004comp_osited
composted16378814comp__osted
comprised1648054compri__sed
comprized2567224compri__zed
compted143813524comp____ted
computed154110954comp___uted
conciliated1645644conciliated
conduplicate1952614conduplicate_
confiscated1953374confiscated
conflated1539334confl__ated
conglobated1753004conglobated
consociated1645214consociated
consolidated1663314consolidated
constipated1645464constipated
convicted1746314co_nvic_ted
cooperated1567334coop_erated
coordinated1553514coordinated
coplotted1444794co_pl_otted
coppiced1734824co_ppic__ed
copulated142710484co_p_ulated
copycatted2051574co_p_ycatted
corelated12411824corel__ated
corticate13410764co_rticate_
coruscated1544464co_ruscated
crepitated1584744crep_itated
cumulated14237844cumul__ated
domesticated1853174domesticated
dominated1339884dom__inated
duplicate1447004_duplicate_
duplicates1546634_duplicates
explicate20117494_explicate_
explicates2196664_explicates
foliated1249914fo__li_ated
fornicated1644824fo_rnicated
homologated1852874homologated
humiliated1643984humili_ated
imbricated1744564_imbricated
imprecated1744404_imprecated
loricated1247894lo__ricated
medicated15410074__medicated
militated1248804__militated
muricated1448244__muricated
nominated1239284nom__inated
obligated13186904_o_bligated
opiated1039484_o_p_i_ated
oppilated1444584_o_ppilated
overcomplicated27152914overcomplicated
placated1338454___placated
plicate11314514___plicate_
pollinated1345824po_llinated
reduplicated1853704reduplicated
replicate13410044_replicate_
replicates1449454_replicates
solicited1247974so__licited
sonicated1248454so__nicated
spicated13309904__sp_icated
supplicate1644524supplicate_
supplicates1744134supplicates
triplicate1445324triplicate_
triplicates1544804triplicates
umbilicated1852654umbilicated
unduplicated1853684unduplicated
unmedicated1744104unmedicated
vellicated1644804_vellicated

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.1701051123.5
2DLD Change Limit1488191579.51615638.8
3Display Results1571570.0931688.2
 (SQL Overall)1786911579.77918272.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.